Importing Sort Codes

Giganews Newsgroups
Subject: Importing Sort Codes
Posted by:  ClaireBrowny
Date: Thu, 16 Aug 2007

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

Replies