|Subject:||Importing Sort Codes|
|Date:||Thu, 16 Aug 2007|
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?