Date format in excel.

[Closed]
Report
Posts
2
Registration date
Friday July 25, 2008
Status
Member
Last seen
July 25, 2008
-
 O-man -
Hello again,

Is there a way to make excel read fields left padded with a 0.


For example I have a program that only reads date format like this yymmdd, so when I open the csv file in excel it reads 080725 as 80725 instead.

Then when I save any changes it saves 80725 instead.

Thank you for any input.

2 replies

Hi

There is a simple way to fix it . This method is without the Macror. Select the column which has the Date in YYMMDD format click on Text to Columns, Click on Fixed with , click on next , click on next , Select Date on the Left top corner . Click on the drop down to chose the format that you want ( E.G.) MDY will give you the Month,Date and Year format. Click on Finish .


Let me know if this help....


Thanks
RJ
3
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Thanks RJ This was very helpfull

Rikus
Like a charm, Thanks!
It's quite simple actually. Under the "Format Cells"menu, click "Custom" and then add a new formatting with 6 zeros "000000". Once set up, you can use this new custom formatting each time needed.