Search : in
By :

Date format in excel.

Last answer on Mar 3, 2009 5:37:35 am GMT munkee, on Jul 26, 2008 12:07:23 am BST 
 Report this message to moderators

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.

Configuration: Windows 2000
Firefox 2.0.0.16

Best answers for « Date format in excel. » in :
Verifying date format in PHP ShowVerifying date format in PHP There are several ways to check the format of a date in PHP; the simplest method is to make use regular expressions. To confirm a date format DD/MM/YYYY, where the days and/or month can be given as...
[Excel] Adding a fixed date in a cell Show[Excel] Adding a fixed date in a cell If you want to insert the current date in a cell in following format DD /MM/YYYY, and that it remains unchanged, without being updated each time the file is opened. Simply type "ctrl" + ";" in the...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Download EMS Data Export for SQL Server ShowDo you need to analyze your data in your SQL Server database? Would you like to print them? EMS Data Export for SQL Server offers to export them into MS Access, MS Excel, MS Word, RTF, HTML, XML, PDF, TXT, CSV, DBF or ODF only in a few steps. This...

1

roostertail, on Nov 6, 2008 3:21:18 pm GMT
  • +1

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.

Reply to roostertail

2

 Ranjith J, on Mar 3, 2009 5:37:35 am GMT
  • +1

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

Reply to Ranjith J