Truncated Zero (0)

C

cdfrank

Greetings,

Does anyone know how to prevent Excel from truncating zero in a Zipcod
field, when the first digit is zero?

I am importing data from a tab-delimited .txt file.

Any help would be appreciated.

cdfran
 
T

Tushar Mehta

In one of the steps of the Import Wizard (don't remember which one) it
asks for the type of each column. Designate the zip code column as
'text'

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2004
 
Top