|
View Full Version : bank Sort Code re-formatting to date KES 12-01-2005, 11:46 PM 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:o shades 12-02-2005, 04:40 AM 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? reclusivemonkey 12-02-2005, 05:23 AM 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:o 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 12-02-2005, 05:26 AM 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. |