bank Sort Code re-formatting to date (1 Viewer)

K

KES

Guest
We have a file with bank sort codes in, and due to the nature of the data, excel is automatically re-formatting these into dates.

Has anyone come across this before, this could be a fairly simple one to resolve.

Many thanks in advance

Kerry:eek:
 

shades

Registered User.
Local time
Today, 07:25
Joined
Mar 25, 2002
Messages
516
Howdy, Kerry, and welcome to the board.

Can you give a few examples or attach a small sample: to show what Excel is showing and what you want it to show?
________
Ford ikon
 
Last edited:

reclusivemonkey

Registered User.
Local time
Today, 12:25
Joined
Oct 5, 2004
Messages
749
KES said:
We have a file with bank sort codes in, and due to the nature of the data, excel is automatically re-formatting these into dates.

Has anyone come across this before, this could be a fairly simple one to resolve.

Many thanks in advance

Kerry:eek:

If you put a single quote

Code:
'10-22-05

in front of the sort code, this will force Excel to treat the contents of the cell as text, but it won't actually show in the resulting cell, you will just get

Code:
10-22-05
 

Jibbadiah

James
Local time
Today, 23:25
Joined
May 19, 2005
Messages
282
Kerry,

Don't include any personal details for any of your customers... no account nos, etc.

The cells could be formatted as date. Try formatting cells as text.

If that doesn't work - you could try copying all the sortcodes and then edit, paste special, as values. Be sure to format the receiving cells as general/text first.

Maybe you could try putting a single quote " ' " in the next cell, and then the third cell could be =A2&A1. This should transform it to text.

J.
 

Users who are viewing this thread

Top Bottom