A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Leading Zeroes



 
 
Thread Tools Display Modes
  #1  
Old April 24th, 2004, 07:16 AM
alex robkin
external usenet poster
 
Posts: n/a
Default Leading Zeroes

if you create the csv file with ="00300",This will display initial zeros!!!

include the equal signs surrounded by quotes....
  #2  
Old April 24th, 2004, 02:18 PM
Peo Sjoblom
external usenet poster
 
Posts: n/a
Default 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  
Old April 24th, 2004, 02:37 PM
David McRitchie
external usenet poster
 
Posts: n/a
Default 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  
Old April 24th, 2004, 03:08 PM
Peo Sjoblom
external usenet poster
 
Posts: n/a
Default 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  
Old April 24th, 2004, 05:50 PM
David McRitchie
external usenet poster
 
Posts: n/a
Default 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  
Old April 24th, 2004, 07:06 PM
Peo Sjoblom
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:40 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.