Is it possible to retain leading zeroes in a text field when saving an Excel csv file ?
Posted on 2013-10-08
I have an Excel 2010 worksheet which I am saving as a .csv file. One of the columns holds telephone numbers as text. However, when I save the file, Excel converts the column to numbers and removes all leading zeroes.
I can't save it as a .txt file as the .csv file is used as input to another software package (WiseSoft Bulk Active Directory Update tool). I've tried prefixing each telephone number with a single quote ' but it is ignored and leading zeroes are removed as before.
Are there any tricks I can apply to get around this problem.