Excel dropping the leading 0s

Fuggan

Fuggan

Fuggan

Associate
Joined
17 Feb 2009
Posts
2,451
Location
Leeds
Does anyone know if there is a setting in MS Excel (2013) that stops the application from automatically dropping the leading 0s from numbers when you open a .csv file?

The only way around it I have found so far is to not actually open the file but import it as text from the csv. Consulted my old pal Google and can't find any help. :(
 
Essentially, at work I deal with customer account numbers and a lot of them are entirely numeric, some of which start with a 0 or even several 0s.

When I double-click-open some .csv files with these customers in, the leading 0s get dropped and 0001123 account number becomes 1123 account (which could be another customer).

When I import the file as text and set the account number column to text, the leading 0s are retained. Just wondered if there was an option to stop them from being dropped upon open the file normally.
 
You must log in or register to reply here.
Back
Top Bottom