How do I stop Excel 2007 from using scientific notation?

Posted to microsoft.public.excel.misc

external usenet poster

Posts: 1

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)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

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 02:08 AM.

Menu

About Us