Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Madeline Ross   on Jan 18 In MS Office Category.

  
Question Answered By: Hisa Yoshida   on Jan 18

In newer versions of Excel, Excel reformats the capitalized version to
lowercase, which is why David said it worked for him. After you questioned
the capitalized versus lowercase, I took a peak. My Excel 2003 reformatted
to yyyymmdd:hhmm

From Help - format  codes:

Days, months, and years If you use "m" immediately after the "h" or "hh"
code or immediately before the "ss" code, Microsoft Excel displays minutes
instead of the month.

To display  Use this code
Months as 1-12 m
Months as 01-12 mm
Months as Jan-Dec mmm
Months as January-December mmmm
Months as the first letter of the month mmmmm
Days as 1-31 d
Days as 01-31 dd
Days as Sun-Sat ddd
Days as Sunday-Saturday dddd
Years as 00-99 yy
Years as 1900-9999 yyyy

Hours, minutes, and seconds To display Use this code
Hours as 0-23 H
Hours as 00-23 hh
Minutes as 0-59 m
Minutes as 00-59 mm
Seconds as 0-59 s
Seconds as 00-59 ss
Hours as 4 AM h AM/PM
Time as 4:36 PM h:mm AM/PM
Time as 4:36:03 P h:mm:ss A/P
Elapsed time  in hours; for example, 25.02 [h]:mm
Elapsed time in minutes; for example, 63:46 [mm]:ss
Elapsed time in seconds [ss]
Fractions of a second h:mm:ss.00

AM and PM If the format contains an AM or PM, the hour is based on the
12-hour clock, where "AM" or "A" indicates times from midnight until noon
and "PM" or "P" indicates times from noon until midnight. Otherwise, the
hour is based on the 24-hour clock. The "m" or "mm" code must appear
immediately after the "h" or "hh" code or immediately before the "ss" code;
otherwise, Microsoft Excel displays the month instead of minutes.

Share: 

 

This Question has 6 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Date and time display custom format ? Or get search suggestion and latest updates.


Tagged: