Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Seperator
I have a date in the YYYY-MM-DD format I need to display it as YYYYMMDD with
no seperators ie / or - Any help much apreciated |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Seperator
Hi,
If it's already a properly formatted date then applying a custom format of YYYYMMDD should do what you require. Mike "burt" wrote: I have a date in the YYYY-MM-DD format I need to display it as YYYYMMDD with no seperators ie / or - Any help much apreciated |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Seperator
Select the cell and click on Format | Cells | Number tab and choose
Custom - enter this in the box: YYYYMMDD Click OK. Hope this helps. Pete On Aug 6, 2:54*pm, burt wrote: I have a date in the YYYY-MM-DD format I need to display it as YYYYMMDD with no seperators ie / or - Any help much apreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use 100 seperator instead of 1000 in excel | Excel Discussion (Misc queries) | |||
Insert a Seperator into a number string. | Excel Discussion (Misc queries) | |||
Removal of thousands seperator | Excel Discussion (Misc queries) | |||
Digit seperator | Excel Worksheet Functions | |||
Thousand Seperator | Excel Discussion (Misc queries) |