Formatting of CSV file
Hi
I've not been on for a while due to ill health, now I'm back and fighting fit However, my first task has me scratching my head...hoping someone can help...
Our IT team send us a .csv file with thousands of addresses but some of the Flat numbers are being converted to dates e.g.
06/04
12 Smith Street
Is being imported as
06-Apr
12 Smith Street
I've tried a couple of different things like converting the column to text and playing around with the options within the wizard with no luck.
To add to the mix, it doesn't seem to be consistent as some of the formatting has been retained correctly.
Does anyone have a solution on how to keep the original formatting?
I'd be hugely thanks :-)
Thanks
Lynn
|