bank Sort Code re-formatting to date

[KES]

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

 

[shades]

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

 

[reclusivemonkey]

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

If you put a single quote

'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

10-22-05

 

[Jibbadiah]

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.