#1
|
|||
|
|||
time formatting
How can I format cell A1 so that when I enter the time in military format in A1, it will display as standard time in A1.
Example:I would like to enter 1400 in A1 and have the same cell display 2:00PM |
#2
|
|||
|
|||
Rightclick on the cell. Choose properties. Under "Number" then "time" use format you want.
|
#3
|
|||
|
|||
Quote:
You could create an event macro that is invoked each time you enter a value; and there, you can convert the data entry. Or you could enter the following formula into a parallel column: =--TEXT(A1,"00\:00"). The double negate converts the text into numeric, interpreting 14:00 as time. In either case, format the cell as Time or Custom hh:mm . Last edited by joeu2004; 08-26-2016 at 01:54 AM. Reason: cosmetic |
#4
|
||||
|
||||
One of the many answers searching the web
http://answers.microsoft.com/en-us/o...6-1cc1de79d2e2 This is a well known problem. Always search the Net first before asking an obvious question
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Employee Turnover by Department/Month split between Voluntary/Involuntary - Full-time/Part-time | CPSmith | Excel | 1 | 03-26-2016 02:48 AM |
VBA Word Table - Select More than 1 Column at a time - Apply Formatting | jc491 | Word VBA | 12 | 09-24-2015 06:03 AM |
Help - Run-time error 91 - VBA for inserting and formatting text depending on style | mtrborges | Word VBA | 2 | 02-08-2015 11:35 PM |
Formatting Merged Time Values Between Excel & Word | JennEx | Mail Merge | 1 | 07-12-2012 02:54 PM |
Cell formatting for time - Excel 2010 | PomDave | Excel | 5 | 09-05-2011 10:49 PM |