csv import into excel, preserving leading zeros in numbers

Hi,
We have csv file automatically generated where rows look like:
"0123","04567","089".
The problem is that when Excel opens this file it puts it into cells like
123,456,89
stripping leading zeros. Is there way to generate csv file so that leading 
zeros won't be stripped so it would like
0123,0456,089 when the file is opened in excel.

Thank you

Vadim



0
vadim1 (1)
1/6/2006 10:07:08 AM
excel 39879 articles. 2 followers. Follow

1 Replies
267 Views

Similar Articles

[PageSpeed] 8

Hi Vadim,

rename the file a .txt file. Then you will have a choice for the type of 
field, number or text

-- 
Kind regards,

Niek Otten

"Vadim" <vadim@dontsend.com> wrote in message 
news:uDjd1jqEGHA.2292@tk2msftngp13.phx.gbl...
> Hi,
> We have csv file automatically generated where rows look like:
> "0123","04567","089".
> The problem is that when Excel opens this file it puts it into cells like
> 123,456,89
> stripping leading zeros. Is there way to generate csv file so that leading 
> zeros won't be stripped so it would like
> 0123,0456,089 when the file is opened in excel.
>
> Thank you
>
> Vadim
>
>
> 


0
nicolaus (2022)
1/6/2006 11:01:23 AM
Reply:

Similar Artilces:

macro to close excel
If I have a macro to automatically run a macro when the workbooks opens, what do I add to make Excel close after the macro finishes running. Thanks, Thisworkbook.Close <true/false/blank> Followed by True to save the changes or False to save with out changing. Leave blank after and excel will prompt you. Nick "Pam C" <PamC@discussions.microsoft.com> wrote in message news:2D5CDA67-F4ED-4156-82E3-EF8F494DE7FF@microsoft.com... > If I have a macro to automatically run a macro when the workbooks opens, > what > do I add to make Excel close after the macro fini...

Default Excel Border Colors
I have Excel 2002. When I try to add a border to a cell, the color defaults to light grey instead of black, even though the color control under Format>> Cells>> Border says "Automatic". How can I change the default color for automatic to be black instead of light grey for ALL spreadsheets? I've seen a similar string about this before, but there was never a resolution that worked. looking forward to your help! bobby See reply in .Misc Biff "Bobby" <bobbyblueicu@hotmail.com> wrote in message news:1116968044.072597.62200@f14g2000cwb.googlegroup...

.CSV to .PRN
I am having trouble saving a .CSV file as a .PRN format - it is cutting the information in the sheet off about 20 columns in - any suggestions? I am doing the basic File - Save as. Thanks, Melissa Have you formatted the sheet with a fixed-width font so you can set the field widths exactly? What is sum of field lengths? There used to be a limit of ~240 characters per line in PRN files. On Mon, 18 Oct 2004 10:13:08 -0700, "Melissa" <Melissa@discussions.microsoft.com> wrote: >I am having trouble saving a .CSV file as a .PRN format - it is cutting the >information i...

cell formatting zero padding on binary no's
I'm struggling through doing some binary math on excel. Ugh. You'd think Excel is written by programmers, so they would see the value of having some programmer-friendly bitwise math and binary, octal and hex formatting stuff in there, if for no other reason than they could use it themselves. Anyway, that's my rant, here's my question I have some numbers in cells that I convert to binary C5: 55 DEC2BIN(C5) gives me 1010101 I'd really like to display that as 0101 0101 .... ie with a leading zero and a space between the nibbles. It appears that ce...

Importing CSV files problem
Hi Guys, I am currently working on a project that invloves importing of CSV files to Excel. Double-clicking the CSV file opens the file automatically in Excel. We have enclosed our data in quotation marks (i.e. "SomeData") to prevent errors arising from strings that have commas as part of the data. This works fine for us. However, The problem arises when we import data that look like numbers written in scientific notation but are actually some other data which should not be expressed in scientific notation (example "1E306" is expressed as "1E+306"). ...

Usable memory in Excel
I seem to remember reading somewhere that there is a limit to the amount of memory that Excel can use, even if you have much more RAM available is the computer. For example, if your computer has 512 mb of RAM, an Excel workbook might be able to use only 50 mb (or whatever) of it. I can't seem to find anything to confirm or refute this. Can anyone help. I am using Excel 2003 on a Windows XP machine. http://www.decisionmodels.com/memlimitsc.htm As you will see, memory constraints were a much bigger issue before Excel 2003. HTH, "Joe Clement" <spam@spam.com> wro...

Why Does Excel Do This ??!!??
Open a new instance of Excel and type a few characters into any cell. Then, open an Excel file attachment from an Outlook message. From this (attachment) book, click the top right (application close) 'X'. Why does Excel try to close the first book in this same action ? In the heat of a busy day it's very easy to confuse the 'Save Changes' file dialog that appears as applying to the current (attachment) notebook, and, especially if it's a book that's unimportant, quickly click no and lose the original workbook. Word doesn't do this - closing an attachment on...

importing incredimail into outlook express
Is there a way, or an add-on. or a third party software to import Incredimail mail into outlook express mail ? ZZ Try posting this in an Outlook Express news group - this is not one of them. Outlook is a part of Microsoft Office and is what this group supports. Outlook Express is a part of Internet Explorer and has its own news groups. You can also find some good Outlook Express information here: http://insideoe.tomsterdam.com --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. All unsolicited mail sent to my personal account will be deleted w...

Excel error while trying to import data from an Access database
This is just an FYI for anyone who might encounter this problem (as I just did)... =-) ::: SYMPTOM ::: In Excel, while trying to create a query into an Access database the following error occurred: MSQRY32.exe has generated errors and will be closed by Windows. You will need to restart the program. ::: CAUSE ::: The Access database contains 'unfavorable' characters in the filename (e.g. "MyAccessDatabase v1.0 (15-Mar-05).mdb" -- it doesn't like the "." and is probably better off without the "(") Rename the database to use a 'safe' file n...

Leading Zeros SQL query
I need to add leading zeros to every item in our RMS database that uses UPCs. Is there an SQL query that could accomplish this? Thanks, Wesley Sanders Hi wesley , I tried this query and it update my itemlookupcode with leading zero where the barcode format is 9(UPCA) but please backup your data before running this query. and before running this ..try to ask for second opinion...I might miss some files that needed to be updated... SQL--> update item set itemlookupcode='0'+ rtrim(ltrim(itemlookupcode)) from item where barcodeformat=9 9=UPCA I hope it helps :) "wessan...

Formulas in International Excel
Hi, I've used Excel in english for a long time, now I'm using a version in my native language (Portuguese). The problem is that the formulas in Excel-pt is in portuguese too - now I'm lost as I need to learn everything again. Is possible to make/config my Excel-pt to use formulas in english and not in Portuguese? Thanks That is depending on version. If you use Excel 2007 then you can purchase language packs to it and switch between the languages. Best wishes Harald "Defranco" <ericofranco@gmail.com> wrote in message news:6b45b6eb-0a87-4abb-b9a5-cfae3000d4...

importing account info into production CRM
Has anyone used the DMF to do a secondary import of data into a live CRM environment? I know it is not intended for this purpose, however in this client's scenario they have no data whatsoever in Accounts (they use only leads and contacts currently, but a different department wants to use accounts now). I want to import some account data that is totally unrelated to their existing contacts. I figure I can use the DMF to do this. Anyone have any thoughts/tips/cautions??? Thanks, -- Matt Wittemann http://icu-mscrm.blogspot.com Dear Matt, It is possible to do this. I have done an imp...

Creating a csv
I have a spreadsheet with a list of email addresses in the first column. I want to create a CSV file. If I choose Save as---> csv and then open the csv file in Notepad the list is saved as a list with carriage returns after each email address and no commas. So how do i turn the list into a continuous list with no breaks and a comma seperating each one? I'm using Excel 2007 Thanks Tony Open the file in MSWord and do an edit|replace (or the MSWord 2007 equivalent) to change the paragraph mark (under the More button and then under the Special button) to a comma. Tony Williams wrote: ...

CSV elements don't get split up in cells
Hi, I recently installed a German version of excel and now when I open m CSV files they don't get seperated anymore by the commas. The whol line is just written in one cell. When I had the US version installed the data was split up after eac comma and distributed into the corresponding cell. How can I achieve the same thing in the German version -- Message posted from http://www.ExcelForum.com tom You could try renaming the file to .txt rather than .csv When you try to open this in Excel it will start the Text Import Wizard which will give you much more control over the import of th...

Excel 2003 #9
Hi there I am unable to find the command "assign macro" to the command button when I use it in a spreadsheet. Is this only available in certain versions . Thank you for any help Terry There are two toolbars that contain buttons. The Forms toolbar has the button you wanted to use. You used a commandbutton from the Control toolbox toolbar. terry b wrote: > > Hi there I am unable to find the command "assign macro" to the command > button when I use it in a spreadsheet. > Is this only available in certain versions . > Thank you for any help > > Ter...

Import data from Excel with main tasks and subtasks
I'm new to MS Project and need help with importing data from Excel into Project 2000. The data consists of Work Request numbers, individual phase numbers for the Work Request, name of each phase, and (phase) start and end dates. I can open the Excel file in Project and map the fields, however, the data shows up as individual tasks. I need to have the Work Request number and project name be a main, or top-level, task, and the data related to the phases be sub-tasks. Here's an example of how the raw data appears in the Excel file: WorkReq# ProjectName Phase# P...

how do I import footnotes to a publisher document ?
When I import a word document into plublisher, the footnotes do not show up. How can I import the Whole document incluiding the footnotes In Publisher 2002, one has to create headers/footers and then copy and paste footnote text, because Publisher 2002 does not support footnotes directly.. Bear in mind that MS Publisher is a frame-based desktop publisher, as opposed to MS Word that is a full blown word processor.. -- Mike Hall MVP - Windows Shell/user "Tripleaxel1" <Tripleaxel1@discussions.microsoft.com> wrote in message news:4765C400-3F5C-4CB4-8FF7-D92BBE2BCD08@micr...

Import #3
I'm trying to import e-mails from Thunderbird but I keep getting an error that "The mail folder could not be opened. If another application is using this file, please close it and try again." There si nothing else using it. I've rebooted, I've coppied the fiels to another directory, I've renamed the files but I can't get my Outlook 2003 e-mails back in Outlook. Thanks. "Brian E" <beshlemanREMOVE@aains.com> wrote in message news:234ee01c45ebf$1f31d320$a601280a@phx.gbl... > I'm trying to import e-mails from Thunderbird but I keep >...

How to do listwise deletion in SPSS or Excel?
Hi, I asked similar question some time ago. However, I still can't completely understand the feedbacks kindly provided. So, I try to ask the question more specificly once again. Imaging in the SPSS or Excel data set, the horizon from left to right are variable 1 to variable 16; the vertical from top to down are invidual reponses 1000 cases. Some individuals don't answer all the 16 questions (variables). I only want the individuals (cases) that answer all the 16 questions (variables). I don't need the invidual cases that don't answer all the 16 questions (variable...

Excel & birthdays
How do I get excel to accept a birthdate by entering keystrokes 09201950 into a cell? Look here http://www.rondebruin.nl/qde.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Norma" <Norma@discussions.microsoft.com> wrote in message news:D68F1D36-5C5A-4803-9DFF-9891BD744BC0@microsoft.com... > How do I get excel to accept a birthdate by entering keystrokes 09201950 into > a cell? Go into Format --> Cell --> Number tab, and select 'Custom'. In the box labelled "Type", you should be able to type in MMDDYYYY. "Norma" wrote...

Saving As .CSV
Hello, here's the situation: I downloaded an .xls file from my broker and opened it in Excel. The original file was delimited by commas and I had to choose comma delimited in order for Excel to display it in columns/rows correctly. I made some changes to the file, then saved it with a new name. The problem is, I can find no way to save it as a comma delimited file again. Saving it as a Workbook places quotes around the commas and creates spacing between text (when I view it in Wordpad), and saving it as a Text File (Tab delimited) does just that--makes it TAB delimited, not comma...

Excel Reader/viewer
Hi folks, I went to MS support and found a reader for Excel 97 & 2000 for the poor souls that don't have Office but...none for 2002 and later. Anyone know why? -- jeff jppolucci@adelphia.net Hi this reader also can open files saved with Excel 2002/2003 -- Regards Frank Kabel Frankfurt, Germany jeffP wrote: > Hi folks, > I went to MS support and found a reader for Excel 97 & 2000 for the > poor souls that don't have Office but...none for 2002 and later. > Anyone know why? Will this reader work for XP Home? I can't find any Home readers for Excel, and I...

footnote numbers not superscripted and are too big
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Power PC For some reason the footnote numbers in my text are full-sized and not superscripted. The notes themselves are OK. That's due to the formatting of your Footnote Reference style. Use Format>Style to change it. Cheers On 19/03/10 10:48 AM, in article 59bb581a.-1@webcrossing.JaKIaxP2ac0, "redhawk@officeformac.com" <redhawk@officeformac.com> wrote: > Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Power > PC For some reason the footnote number...

Import of PST Files into Exchange 2003
Hi All, I am setting up an Exchange 2003 environment and was wondering if there was a limit to the PST file size that can be imported into a users mailbox. We have a coupe of users who have PST files of about 1 1/2 GB and I needed to know if I would have a problem importing files of this size. Thanks for any insights. Kev wrote: > Hi All, > > I am setting up an Exchange 2003 environment and was wondering if > there was a limit to the PST file size that can be imported into a > users mailbox. > > We have a coupe of users who have PST files of about 1 1/2 GB and I > n...

Automatic import
Hi, Do you know a command line to import data from files ? I just want to do an automatic import from a dbf file every day without any intervention from a user. Is it possible ? Thx I don't think there's a command line for it. You'd either have to write code that uses the API to do what you want or use a button-pressing script to do what you want. "news.microsoft.com" <personne@microsoft.com> wrote in message news:Ou5VnOATGHA.196@TK2MSFTNGP10.phx.gbl... > Hi, > > Do you know a command line to import data from files ? > I just want to do an aut...