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

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

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