Importing Sort Codes

C

ClaireBrowny

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
 
J

Joel

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

Converting this raw data into something formulaic 4
Conditional Formatting 1
Sorting Date Column 1
Calculating occupational sick pay entitlement 0
CSV imported data being formatted as a date 2
Auto Formatting hours of .csv file 2
Formatting with imported data 2
convert text to date 3

Top