Importing Sort Codes

G

Guest

Hi there
Currently importing banking data that includes sort codes but EXcel 2003 is
automatically converting the 01-07-07 format into date format 01/07/07. When
I format to Custom or Text it appears as 39264. Any suggestions on a formula
I can run to convert them all to the correct value in text/custom format?
Thanks
Claire
 
G

Guest

Don't convert then to text! 39264 is just the number of days since
Jan-01-1900. Microsoft started there time zero in 1900. All you have to do
is highlight the column of data. Then go to Tool Menu - Format - Cells -
Number - Date and select one of the date formats. The numbers will all
change to dates.
 

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

CSV imported data being formatted as a date 2
Date Format Problem 3
Conditional Formatting 1
How do I convert date values to non-date format e.g. 01-06-78? 2
Date glitch? First 12 days of month format differently than the r 3
Regional Settings with Date 3
Date is not displaying correctly 9
Filter (blanks) with two or more unique values not working 1

Top