| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need a yyyymmdd date format with no dashes
where can i find it?!
its not under the English drop down only with the dashes |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need a yyyymmdd date format with no dashes
Select the cell(s); use Format | Cells; open the Custom tab and in the text
box enter yyyymmdd This will give you the format you need best wishes & Merry Christmas -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "EXCEL HELP PLEASE" <EXCEL HELP wrote in message ... where can i find it?! its not under the English drop down only with the dashes |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need a yyyymmdd date format with no dashes
Click on Format, Cells, select Custom, enter yyyymmdd and you have it
-- Hth Kassie Kasselman "EXCEL HELP PLEASE" wrote: where can i find it?! its not under the English drop down only with the dashes |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Date Format Problem | Excel Discussion (Misc queries) | |||
| EASY cond format Date?? | Excel Discussion (Misc queries) | |||
| Customized Date Format | Excel Worksheet Functions | |||
| format date in excel | Excel Discussion (Misc queries) | |||
| date format in excel not in line with control panel regional setti | Excel Discussion (Misc queries) | |||
Linear Mode
