B burt Aug 6, 2008 #1 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
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
M Mike H Aug 6, 2008 #2 Hi, If it's already a properly formatted date then applying a custom format of YYYYMMDD should do what you require. Mike
Hi, If it's already a properly formatted date then applying a custom format of YYYYMMDD should do what you require. Mike
P Pete_UK Aug 6, 2008 #3 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
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