Hi...how to set date format for excel sheet.

March 8, 2012 at 23:05:55
Specs: Windows 7
i am having an excel sheet for bulk upload process.In that i have to enter date as a data in one column.my date should be in dd-mm-yyyy format.From 13 to 31st excel is accepting dd-mm-yyyy format.but for 01 t0 12 its taking values as dd/mm/yyyy format.
so how can i set a column completely into dd-mm-yyyy format??

See More: Hi...how to set date format for excel sheet.

Report •

#1
March 10, 2012 at 07:11:37
Try using Custom Formatting,

Your data will be stored as dd/mm/yyyy but will Display as dd-mm-yyyy

Just use the Custom Format of: mm-dd-yyyy

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question