csv format changes numbers

I need to save my file in a csv format. When the file is reopenned, some of 
the numbers are in a date format and others are in exponential format. How 
can I format the number to keep the numbers from changing format. I have 
tried various formats before savint the file. In this instance, the numbers 
represent part numbers and the file is being imported into my business 
software to update pricing. 
-- 
Bob
0
Bobbr (1)
5/21/2008 2:04:01 PM
excel.newusers 15348 articles. 2 followers. Follow

1 Replies
595 Views

Similar Articles

[PageSpeed] 50

If you are re-opening in Excel, the behaviour you describe is typical.

Have you tried opening the *.csv file in Notepad or similar application?


Gord Dibben  MS Excel MVP

On Wed, 21 May 2008 07:04:01 -0700, Bobbr <Bobbr@discussions.microsoft.com>
wrote:

>I need to save my file in a csv format. When the file is reopenned, some of 
>the numbers are in a date format and others are in exponential format. How 
>can I format the number to keep the numbers from changing format. I have 
>tried various formats before savint the file. In this instance, the numbers 
>represent part numbers and the file is being imported into my business 
>software to update pricing. 

0
Gord
5/21/2008 11:39:56 PM
Reply:

Similar Artilces:

.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...

Shared workbook-track changes off but file size still grows
I have a shared workbook with track changes off. I turned it off because I have a macro to arrange the rows in a certain way which created a huge log. The problem is that the file keeps growing. It starts out at 570k and by noon, it is at 15 Mb. To bring it back down, I have to take the book off shared, and put it back on and it is back to normal. Does anybody know the problem or know someone's website with experience in shared workbooks? Joe ...

Does anyone have a format or template for a Education Cover Letter
Does anyone have a format or template for a Education Cover Letter? To Whom It May Concern: Enclosed please find an education. Sincerely, eb -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "eb" <eb@discussions.microsoft.com> wrote in message news:4CEF7B84-6F7A-4D07-97B3-F349F3B11E54@microsoft.com... > Does anyone have a format or template for a Education Cover Letter? > "Suzanne S. Barnhill" <sbarnhill@mvps.org> wrote in message news:O3aNFsq2KHA.5212@TK2MSFTNGP04.phx.g...

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: ...

tsql to change oracle pswd
Is it possible to use tsql or sqlcmd to change an Oracle password? Chuck (nospam34@nospam.nospam) writes: > Is it possible to use tsql or sqlcmd to change an Oracle password? EXEC ('ORACLE CMD TO CHANGE PASSWORD') AT OracleSVR -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx thanks, it seems so obvious now ...

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"). ...

changing item type
I have a lot of items added as sales inventory that should be services or misc charge. Can I go into the back end and change this? How would this work for items that have have or have had transactions associated with them? Thank you for any assistance. Well it works poorly. If you have quantities on hand, these need to be adjusted out first. The best option is to create new items with the proper settings and change the others to discontinued. -- Richard L. Whaley Author / Consultant / MVP Documentation for Software Users Get our Free Tips and Tricks Newsletter and check out our book...

number keep being formatted as date
Hi: I'm a newbie so forgive me if this question has been answered. I couldn't find much with the search option. Okay here's the problem.:confused: :eek: I want to enter this: 1-2 into a cell but Excel keep turning it into 2-Jan. How do I turn this off? the 1-2 is just a designation of point 1 to point 2. Thank you for helping. -- baxu ------------------------------------------------------------------------ baxu's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27861 View this thread: http://www.excelforum.com/showthread.php?threadid=4736...

Custom Date Format #2
When working with data from a spreadsheet which originated from a much earlier version of Excel (Excel95, I believe), which I'm now trying to use with Excel 2003. I'm having trouble with the formatting of the date being interpreted as a formula and forcing an equals sign "=" to appear next to the data. When the file is first opened, the original data appears correctly. However, after editing the data in the field and pressing the 'enter' key, the date displayed on the sheet shows "00-Jan-00". When I use the arrow keys to go back up to that parti...

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...

formatting cells #3
Question: Recently, when attempting to format cells, whether it's for color fill or lines, boldface for type,and a variety of other cell formats--I now get a warning box which says 'too many different cell formats' even when I work with a duplicate of the spread sheet from which I have cleared all formats. Is there some way to correct this malfunction. I have worked for over ten years with excel and have not had this problem. It appeared on my G4 and now has carried over to my G5. I'm running Excel 2004 11.3 Frank Excel has a limit for the number of different formats it can...

Change Outlook 2002 from Internet mode to corporate mode
Currently, I have installed Outlook 2002 in Internet Only mode. How do I change to Corporate or workgroup mode? Thanks. On Thu, 6 Nov 2003 15:44:50 -0800, "wayne" <anonymous@discussions.microsoft.com> wrote: >Currently, I have installed Outlook 2002 in Internet Only >mode. > >How do I change to Corporate or workgroup mode? > Outlook 2002 does not use 'modes'. -- Rich Cervenka Chicago, Illinois, USA Email Client: Microsoft Outlook 2002/2003 News Client (Text): Fort� Agent 1.93 www.forteinc.com News Client (Binaries): News Rover 9.0 www.newsrov...

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...

Changing Costs in Detailed Sales Report
I just opened a new location and I have specified my costs in HQ Mgr under Supplier Tab in Item properties. And I also checked the Supplier tab in Item properties in the Store Ops Mgr, my cost is there. But when I ran a Detailed Sales report for yesterday, some of my items' costs are missing and listed as $0.00. So I open HQ Mgr and issued Worksheet 302 for the new location. I did a couple of test transactions today and ran a Detailed Sales report for today, and it shows the costs of the the test trasactions. But detailed sales report for yesterday still shows $0.00 costs. How do...

Block HTML Formatting?
I have a web-based app that accepts emails sent to it by Exchange users. I'd like to have Exchange format those emails so that if my users send mail with HTML formatting in the email the emails will be converted to plain text before being forwarded to my app server. Is that possible in Exchange? rickKasten@gmail.com (DrStrangepork) wrote in news:a4cf4e10.0409141239.440d0853@posting.google.com: > I have a web-based app that accepts emails sent to it by Exchange > users. I'd like to have Exchange format those emails so that if my > users send mail with HTML formatting in t...

change user's properties
Hi everybody This "problem" seems tricky to me and I'm not sure if it is related exactly to the Exchange or the AD: When I start typing the name of a user in the To: field of a new message in Outlook, I get the suggestion of the name of the user. This suggestion is the name of the user followed by SOMETHING in "<" and ">". The problem is that the SOMETHING is wrong! I can see the same value in the user's properties in Outlook, in the last tab (E-mail addresses), in a line starting with X400 and then a property starting with "s=" ...

Parsing CSV
Hi, im using A file with records in my mfc application, i need to read*/write records to the file anybody ahs a clue where should i start? Take a look at CStdiofile and CString::Format() (for output) and CString::Tokenize() (for parsing input). You can use ReadString() and WriteString() to access the file line by line. Tom "fima" <fkpkot@gmail.com> wrote in message news:eXA9vp95FHA.1184@TK2MSFTNGP12.phx.gbl... > Hi, > im using A file with records in my mfc application, i need to read*/write > records to the file anybody ahs a clue where should i start? >...

Format Axis
I have a line chart which is pulling data from a different sheet in my workbook. The X axis is the date, formatted: Jan-XX, Feb-XX, etc. The Y axis is dollar amounts formatted as 200000, 400000, etc. - increasing by 200K at each interval. - this is correct. The X axis is defaulting to date the same date all the way across, "Jan-00, Jan-00, Jan-00". So, I'm seeing Jan-00 12 times, where I would like to see each month of the year. When I change the X axis to so that it reads each month, as I'd like... The scale on my Y axis changes to: min = 0 (this is correct) ma...

Is it possible to change the default number format in Excel?
Is it possible to change the default number format in Excel? You can change it, but I bet you won't want to. You can change the normal style of a workbook by: format|style|choose normal from the dropdown click on the modify button and change the format to what you want. First bad thing: Styles are kept with workbooks. So you'll have to do this to any new or existing workbook. Partial good thing: You can create a workbook template named book.xlt and store it in your XLStart folder. If you change the normal style for this template file, then any new workbook that you start by...

Format date to UPPERCASE
Excel 97: Is there a way to format the date, currently set to "dddd, mmmm d, yyyy", in uppercase letters? Hi Bruce, If by "Date" you're referring to the current date, this formula should accomplish what you're looking for: =UPPER(TEXT(NOW(),"dddd, mmmm d,yyyy")) I hope this helps. Paul "Bruce LeBlanc" <blebl19@att.net> wrote in message news:<OVHfBuYUDHA.964@TK2MSFTNGP09.phx.gbl>... > Excel 97: Is there a way to format the date, currently set to "dddd, mmmm d, > yyyy", in uppercase letters? Niek and Paul, Th...

Date format problems
2006-02-03-01.48.09.698000 I have a column that consist of a date/start time stamp (as shown above). I have changed the format of the column using custom that follows this format, however when I try to scatter chart this, I get at 1900-01-00, 1900-01-10 etc. for one of the axis. Any idea how to keep the original contents and why is it going to a 1900 year? Thanks in advance! -- Monty ------------------------------------------------------------------------ Monty's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33605 View this thread: http://www.excelforum.com/s...

Contract lines - number of items
Hello, Just started with MS CRM 3.0. I have set up contracts and contract lines, based on a Time template, for my clients. Normally their contract duration is a year with monthly billing intervals, so my question is do I: - Enter the full year's minutes in the time allotment or can I (preferred): - Enter only a months minutes in the time allotment, but put Quantity at 12. My intention here is to reset the months minutes each month. TIA Tony I was just wondering if you had found out the procedure, i am in the same boat! TIA "Tony" wrote: > Hello, > > Just star...

Conditional Formatting
Hi, Is there a way that when you insert rows, the conditional formatting on the adjacent rows does not copy into the inserted/new row? Thanks, Here are tow ways of inserting a row when the text changes in Column A (I don't know why you are inserting rows). Sub InsertRow_At_Change() Dim LastRow As Long Dim x As Long LastRow = Cells(Rows.Count, 1).End(xlUp).Row Application.ScreenUpdating = False For x = LastRow To 3 Step -1 If Cells(x, 1).Value <> Cells(x - 1, 1).Value Then If Cells(x, 1).Value <> "" Then If Cells(x - 1, 1).Value <> "...

legacyExchangeDN
I have a Exchange2K3 server on a Windows2K3. It is an upgrade of Exchange5.5 on WinNT. The lay out was a bit different, and some mailboxes have inherited "unwanted" values in that "legacyExchangeDN" property: recipient containers which no longer exist, mailbox (hidden) names from a different naming policy, etcetera. May I change at will that property for several users? ... without having to reinstall my whole server, of course ;-) -- TIA R� Why? Is it broken? It *could* be changed, although I advise you be careful changing that. Test the heck out of it in your en...