| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date format?
I have Excel 2003 SP2...How do I format the date as 8 figures like this
01/09/2007...the leading 0's are always dropped and I need them to show? -- Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date format?
Right click the cell, select format cells, select the Number tab, select
Date, and then select the type that corresponds to your needs, in this case, 03/14/01 Dave -- Brevity is the soul of wit. "TOMD" wrote: I have Excel 2003 SP2...How do I format the date as 8 figures like this 01/09/2007...the leading 0's are always dropped and I need them to show? -- Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date format?
Dave:
I need the 8 figures with the leading zeros! -- Thanks! "Dave F" wrote: Right click the cell, select format cells, select the Number tab, select Date, and then select the type that corresponds to your needs, in this case, 03/14/01 Dave -- Brevity is the soul of wit. "TOMD" wrote: I have Excel 2003 SP2...How do I format the date as 8 figures like this 01/09/2007...the leading 0's are always dropped and I need them to show? -- Thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date format?
FormatNumberCustom................dd/mm/yyyy
Gord Dibben MS Excel MVP On Tue, 9 Jan 2007 09:59:00 -0800, TOMD wrote: I have Excel 2003 SP2...How do I format the date as 8 figures like this 01/09/2007...the leading 0's are always dropped and I need them to show? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date format?
That does it...Many Thanks!
- Thanks! "Gord Dibben" wrote: FormatNumberCustom................dd/mm/yyyy Gord Dibben MS Excel MVP On Tue, 9 Jan 2007 09:59:00 -0800, TOMD wrote: I have Excel 2003 SP2...How do I format the date as 8 figures like this 01/09/2007...the leading 0's are always dropped and I need them to show? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date format?
Excellent news.
Gord On Tue, 9 Jan 2007 11:40:03 -0800, TOMD wrote: That does it...Many Thanks! - Thanks! "Gord Dibben" wrote: FormatNumberCustom................dd/mm/yyyy Gord Dibben MS Excel MVP On Tue, 9 Jan 2007 09:59:00 -0800, TOMD wrote: I have Excel 2003 SP2...How do I format the date as 8 figures like this 01/09/2007...the leading 0's are always dropped and I need them to show? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a month to a quarter ...... | New Users to Excel | |||
| Excel 2007 Date Format Problem | Excel Discussion (Misc queries) | |||
| EASY cond format Date?? | Excel Discussion (Misc queries) | |||
| MS Query Date Format | Excel Discussion (Misc queries) | |||
| Customized Date Format | Excel Worksheet Functions | |||
Linear Mode
