Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to stop the 0 from dropping when saving exel to a .csv file
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to stop the 0 from dropping when saving exel to a .csv file
precede the part number with single quote
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to stop the 0 from dropping when saving exel to a .csv file
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) -- Gary's Student "danny boahn" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to stop the 0 from dropping when saving exel to a .csv file
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. Gary''s Student wrote: 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) -- Gary's Student "danny boahn" wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop Excel from dropping leading zeros? | Excel Discussion (Misc queries) | |||
Saving a csv file with out dropping 0 | Excel Worksheet Functions | |||
How do I stop Series Line from Dropping to Zero | Excel Discussion (Misc queries) | |||
How do I stop Excel from saving a file with a different name? | Excel Discussion (Misc queries) | |||
How do I stop Excel 2000 from saving file history from file that . | Excel Discussion (Misc queries) |