If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Leading Zeroes
if you create the csv file with ="00300",This will display initial zeros!!!
include the equal signs surrounded by quotes.... |
#2
|
|||
|
|||
Leading Zeroes
So what's the point of doing that?
You can open the csv file using dataimport external data, select all file types and import the column as text. -- Regards, Peo Sjoblom "alex robkin" wrote in message ... if you create the csv file with ="00300",This will display initial zeros!!! include the equal signs surrounded by quotes.... |
#3
|
|||
|
|||
Leading Zeroes
Sounds like it might be helpful as... You only have a choice
if you change the file extension to .txt instead of .csv This way another program could generate the .csv file and it could be opened in Excel without intervention. Of course it would be nicer if the entire column were text so that new entries added would be text as well (I don't put too much reliance on the Extend Formulas and Formats). --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "Peo Sjoblom" wrote in message ... You can open the csv file using dataimport external data, select all file types and import the column as text. "alex robkin" wrote in message ... if you create the csv file with ="00300",This will display initial zeros!!! include the equal signs surrounded by quotes.... |
#4
|
|||
|
|||
Leading Zeroes
No, you are wrong. No need to change the file extension.
Try it.. Do dataimport external dataimport data, in the dialogue box files of type select all files or type *.* find the csv file and open it and the text import wizard will start. -- Regards, Peo Sjoblom "David McRitchie" wrote in message ... Sounds like it might be helpful as... You only have a choice if you change the file extension to .txt instead of .csv This way another program could generate the .csv file and it could be opened in Excel without intervention. Of course it would be nicer if the entire column were text so that new entries added would be text as well (I don't put too much reliance on the Extend Formulas and Formats). --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "Peo Sjoblom" wrote in message ... You can open the csv file using dataimport external data, select all file types and import the column as text. "alex robkin" wrote in message ... if you create the csv file with ="00300",This will display initial zeros!!! include the equal signs surrounded by quotes.... |
#5
|
|||
|
|||
Leading Zeroes
Hi Peo,
Thanks for reiterating that, hadn't really paid enough attention to your answer or to the options on the menu even though I say one of the best ways to learn Excel is to go through the menus. In any case a direct open of a file is easier, and that includes double-clicking to open so if the formula is picked up automatically from a .csv file that would certain make computer generated data from say mainframes a lot easier to read into Excel. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Peo Sjoblom" wrote... No, you are wrong. No need to change the file extension. Try it.. Do dataimport external dataimport data, in the dialogue box files of type select all files or type *.* find the csv file and open it and the text import wizard will start. |
#6
|
|||
|
|||
Leading Zeroes
I agree, plus if you use the method I posted you have import it into a
workbook, I just wanted to show that there is way, albeit less useful. -- Regards, Peo Sjoblom "David McRitchie" wrote in message ... Hi Peo, Thanks for reiterating that, hadn't really paid enough attention to your answer or to the options on the menu even though I say one of the best ways to learn Excel is to go through the menus. In any case a direct open of a file is easier, and that includes double-clicking to open so if the formula is picked up automatically from a .csv file that would certain make computer generated data from say mainframes a lot easier to read into Excel. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Peo Sjoblom" wrote... No, you are wrong. No need to change the file extension. Try it.. Do dataimport external dataimport data, in the dialogue box files of type select all files or type *.* find the csv file and open it and the text import wizard will start. |
Thread Tools | |
Display Modes | |
|
|