how to stop the 0 from dropping when saving exel to a .csv file

[Guest]

I am making a price sheet in exel. The part numbers start with a 0. When I am
saving the file in a .csv the 0 is dropping off the part number how can I
stop it

 

[sugargenius]

precede the part number with single quote

 

[Guest]

When you save in .csv format, leading zeros should be preserved. Do this
experiment :

1. Format A1 as Text
2. Enter 00 in A1
3. Save the file as .csv

Open the file in Word, Notepad, or Wordpad and you will see the double zeros.

If you open the .csv file by double clicking the file icon, Excel will
start and all you will see is a single zero.

To get the double zero to appear when re-opening the file, first start Excel
and then pull-down File > Open and specify the .csv file.

The Import wizard should start and allow the real double zero to be imported
(as a Text Field)

 

[Dave Peterson]

If the file is named .csv then when you do the File|open, you won't see the text
import wizard.

Renaming the .csv file to .txt would work, though.