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 |
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 |
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 |
All times are GMT +1. The time now is 07:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com