A Microsoft Excel forum. ExcelBanter

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 » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How do I stop Excel 2007 from using scientific notation?



 
 
Thread Tools Display Modes
  #1  
Old January 14th 10, 06:23 PM posted to microsoft.public.excel.misc
jonnyjd
external usenet poster
 
Posts: 1
Default How do I stop Excel 2007 from using scientific notation?

I need to stop Excel 2007 from changing a location code (38E2) to scientific
notation. This file needs to be in a CSV format. I have formatted the cell
as TEXT and tried using the single quote before the data ('38E2). Each time
i reopen the CSV file, any cell with that same format (xxEx) turns back to
scientific notation. (Ex. 38E2 > 3.80E03, 42E2 > 4.20E03, etc)
Ads
  #2  
Old January 14th 10, 07:07 PM posted to microsoft.public.excel.misc
David Biddulph[_2_]
external usenet poster
 
Posts: 8,651
Default How do I stop Excel 2007 from using scientific notation?

If you've got a text value of 38E2 in the cell, that will be what is in the
CSV file. You can check by reading the CSV with something like notepad.
The problem arises if you open the CSV with Excel and allow Excel to decide
how to interpret the data.

Rather than just opening the CSV with Excel, if you want to read it with
Excel, use what in Excel 2003 is the "Data/ Import External Data ..."
feature, which allows you to specify that the relevant columns should be
read as Text, not General format. I understand that the Excel 2007
equivalent is "Data/ Get External Data ...".
--
David Biddulph


"jonnyjd" > wrote in message
...
>I need to stop Excel 2007 from changing a location code (38E2) to
>scientific
> notation. This file needs to be in a CSV format. I have formatted the
> cell
> as TEXT and tried using the single quote before the data ('38E2). Each
> time
> i reopen the CSV file, any cell with that same format (xxEx) turns back to
> scientific notation. (Ex. 38E2 > 3.80E03, 42E2 > 4.20E03, etc)



  #3  
Old January 14th 10, 07:32 PM posted to microsoft.public.excel.misc
JLatham
external usenet poster
 
Posts: 2,204
Default How do I stop Excel 2007 from using scientific notation?

You'd get the same seeming bad behavior out of Excel 2003 also. You may have
noticed a warning that "some features" of your workbook were incompatible
with the CSV file format. Excel was just trying to hint that you were going
to have this problem when you open the file later on.

One way to deal with it, perhaps not the answer you were looking for, is to
open a new workbook and then use Data --> Import External Data and then
select the group with .csv and .txt file types in it and work through the
definition of the import process, and at one point you can tell it that the
column for that group is to be imported as TEXT!! not converted to scientific
notation.

Hope that helps at least a little.

"jonnyjd" wrote:

> I need to stop Excel 2007 from changing a location code (38E2) to scientific
> notation. This file needs to be in a CSV format. I have formatted the cell
> as TEXT and tried using the single quote before the data ('38E2). Each time
> i reopen the CSV file, any cell with that same format (xxEx) turns back to
> scientific notation. (Ex. 38E2 > 3.80E03, 42E2 > 4.20E03, etc)

 




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 On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel reading pasted values as Scientific Notation Brad Autry Excel Discussion (Misc queries) 2 September 8th 09 05:00 PM
HOW DO I STOP AUTOMATIC SCIENTIFIC NOTATION IN A CELL crankyhank Excel Discussion (Misc queries) 2 April 4th 07 09:59 PM
Scientific Notation - I want excel to read it as a text not a numb Jim McC Excel Discussion (Misc queries) 1 February 19th 07 08:08 PM
Excel 2003 won't let me change Xlabels from scientific notation CVb Charts and Charting in Excel 1 December 30th 05 02:22 PM
scientific notation to display 1.8 x 10-5 in Excel feloniousmoney New Users to Excel 1 July 6th 05 10:31 PM


All times are GMT +1. The time now is 11:41 PM.


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