Date format in excel.

Closed
munkee
Posts
2
Registration date
Friday July 25, 2008
Status
Member
Last seen
July 25, 2008
- Jul 25, 2008 at 07:07 PM
 O-man - Sep 28, 2012 at 12:15 PM
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
Thanks RJ This was very helpfull

Rikus
0
Like a charm, Thanks!
0
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.
-2