Date format in excel. Closed

Question

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.

Ranjith J · Accepted Answer

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

roostertail · Answer

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.

Date format in excel.

2 responses

Similar discussions

Subscribe To Our Newsletter!