Posted to microsoft.public.excel.misc

crankyhank crankyhank is offline

external usenet poster

Posts: 1

HOW DO I STOP AUTOMATIC SCIENTIFIC NOTATION IN A CELL

When entering a part number such as 419E1 the cell defaults to scientific and
displays - 4190 - unless I use a ' before this kind of part number. If I
re-enter a normal number after that, the cell remains in the scientific mode.

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
Prevent Scientific Notation	robbyp	Excel Discussion (Misc queries)	3	February 20th 07 03:13 PM
scientific notation	T.Reisz	Excel Discussion (Misc queries)	4	June 12th 06 01:59 PM
Truncate scientific notation	Topher	Excel Worksheet Functions	1	March 21st 05 10:28 PM
Scientific Notation when graphing	Bates Senior Thesis Researcher	Charts and Charting in Excel	6	March 17th 05 06:58 PM
Scientific notation	Clive	Excel Discussion (Misc queries)	2	February 8th 05 11:38 PM

All times are GMT +1. The time now is 10:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us