How to stop Excel from automatically truncating leading zeros
No default for this.
Are you able to change the extension of the *.csv files to *.txt
If so, when you open them the Text Wizard will open and you can designate
text formatting for each column.
Gord Dibben MS Excel MVP
On Tue, 13 Apr 2010 14:31:02 -0700, Kenny A.
wrote:
Is there a setting in Excel 2007 to keep it from automatically trunkating
leading zeros like when pasting in zip codes or department codes. When Excel
sees what it thinks is a number, it treats it like a number and drops leading
zeros. Is there a setting in Options or somewhere to tell excel to leave the
leading zeros. We open lots of CSV files in EXCEL and it sees a number (such
as a department code) and drops the leading zeros. In simple, does Excel have
a setting to prevent this from happening as a default????
Thanks
Kenny
|