Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV - text
I have "00012345" in a CSV file. when i open the CSV in excel, it comes up as
"12345". WITHOUT adding the apostrophe "'00012345" , how else can i get it to display the zeros in front of the numbers (because it's text, not numeric)? and the users don't want to go into format-cells each time. any global settings for this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV - text
The problem is how you are openning the file.
If you double-click the icon or, from Excel, do: File Open then Excel tries to "help" you by dropping leading zeros. Instead: Data Import External Data Import Data and then tell the Wizard that the field is text. The leading zeros will be preserved. Another method is to rename the file something other than .csv -- Gary''s Student - gsnu200766 "pacificwaters" wrote: I have "00012345" in a CSV file. when i open the CSV in excel, it comes up as "12345". WITHOUT adding the apostrophe "'00012345" , how else can i get it to display the zeros in front of the numbers (because it's text, not numeric)? and the users don't want to go into format-cells each time. any global settings for this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV - text
the users don't want to do the wizard every time and specify that each field
is text. we are working with alot of fields and this becomes very inconvenient. any other ways to easily set a global option so that we don't ever have to perform these steps? thanks for the reply. "Gary''s Student" wrote: The problem is how you are openning the file. If you double-click the icon or, from Excel, do: File Open then Excel tries to "help" you by dropping leading zeros. Instead: Data Import External Data Import Data and then tell the Wizard that the field is text. The leading zeros will be preserved. Another method is to rename the file something other than .csv -- Gary''s Student - gsnu200766 "pacificwaters" wrote: I have "00012345" in a CSV file. when i open the CSV in excel, it comes up as "12345". WITHOUT adding the apostrophe "'00012345" , how else can i get it to display the zeros in front of the numbers (because it's text, not numeric)? and the users don't want to go into format-cells each time. any global settings for this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV - text
the users don't want to do the wizard and specify text for each field every
time. we are working with alot of fields and this becomes very inconvenient. any easier way on setting a global option so that we don't ever have to perform these steps? thanks for the reply. "Gary''s Student" wrote: The problem is how you are openning the file. If you double-click the icon or, from Excel, do: File Open then Excel tries to "help" you by dropping leading zeros. Instead: Data Import External Data Import Data and then tell the Wizard that the field is text. The leading zeros will be preserved. Another method is to rename the file something other than .csv -- Gary''s Student - gsnu200766 "pacificwaters" wrote: I have "00012345" in a CSV file. when i open the CSV in excel, it comes up as "12345". WITHOUT adding the apostrophe "'00012345" , how else can i get it to display the zeros in front of the numbers (because it's text, not numeric)? and the users don't want to go into format-cells each time. any global settings for this? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV - text
No.
-- David Biddulph "pacificwaters" wrote in message ... the users don't want to do the wizard every time and specify that each field is text. we are working with alot of fields and this becomes very inconvenient. any other ways to easily set a global option so that we don't ever have to perform these steps? thanks for the reply. "Gary''s Student" wrote: The problem is how you are openning the file. If you double-click the icon or, from Excel, do: File Open then Excel tries to "help" you by dropping leading zeros. Instead: Data Import External Data Import Data and then tell the Wizard that the field is text. The leading zeros will be preserved. Another method is to rename the file something other than .csv -- Gary''s Student - gsnu200766 "pacificwaters" wrote: I have "00012345" in a CSV file. when i open the CSV in excel, it comes up as "12345". WITHOUT adding the apostrophe "'00012345" , how else can i get it to display the zeros in front of the numbers (because it's text, not numeric)? and the users don't want to go into format-cells each time. any global settings for this? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV - text
In that case open the file in Notepad and do a find and replace
"0 - "'0 pacificwaters wrote: the users don't want to do the wizard every time and specify that each field is text. we are working with alot of fields and this becomes very inconvenient. any other ways to easily set a global option so that we don't ever have to perform these steps? thanks for the reply. "Gary''s Student" wrote: The problem is how you are openning the file. If you double-click the icon or, from Excel, do: File Open then Excel tries to "help" you by dropping leading zeros. Instead: Data Import External Data Import Data and then tell the Wizard that the field is text. The leading zeros will be preserved. Another method is to rename the file something other than .csv -- Gary''s Student - gsnu200766 "pacificwaters" wrote: I have "00012345" in a CSV file. when i open the CSV in excel, it comes up as "12345". WITHOUT adding the apostrophe "'00012345" , how else can i get it to display the zeros in front of the numbers (because it's text, not numeric)? and the users don't want to go into format-cells each time. any global settings for this? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV - text
If your data is laid out exactly the way each time, you could rename the *.csv
file to *.txt and provide a macro that would open the file so that each field is treated the way you want it. Rename the file to .txt and record a macro when you open it and you'll have the code. If the format of the file varies, you may not be able to macro-ize it. It would depend on that variation. pacificwaters wrote: I have "00012345" in a CSV file. when i open the CSV in excel, it comes up as "12345". WITHOUT adding the apostrophe "'00012345" , how else can i get it to display the zeros in front of the numbers (because it's text, not numeric)? and the users don't want to go into format-cells each time. any global settings for this? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
grab cell text from multi-tab workbook, show text in another workb | Excel Worksheet Functions | |||
Sumif text is contained winthin a longer text string in a cell | Excel Worksheet Functions | |||
Text does not display in "Text boxs" and when wrapping text in a c | Excel Discussion (Misc queries) | |||
text (3750 char.)truncates with text wrap and row heigh adjusted? | Excel Discussion (Misc queries) | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions |