Modify general format to date format.

S

SherryS

When importing from payroll, it gives me all dates formatted as general
numbers (i.e. 07/17/2009 is presented as 7172009. Is there any way to
convert these numbers into dates?
 
J

Jacob Skaria

If your Windows Regional Settings recognise a format of mddyyyy, you can
apply the below formula and format the formula cell to date..

=--TEXT(A1,"00\-00\-0000")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Date Formats 4
Address Format changed after Migration 0
Setting column width in a table with a macro is not working 0
convert 13.11.2009 general to 13/11/2009 date, how to 2
Convert PDF to Visio File or Editable PDF in Visio 0
Subtracting time...again 2
Peculiar default cell format 1

Top