Posted to microsoft.public.excel.programming

Otto Moehrbach Otto Moehrbach is offline

external usenet poster

Posts: 1,090

Avoid Scientific Notation

Excel XP & Win XP
I have a 9 digit number. With VBA I copy that number to another cell.
Excel insists in displaying the number in the second cell in scientific
notation.
The original number is not a mathematical quantity so I can make it text.
Even if I do, it still pastes in scientific notation.
How can I copy/paste that entry as a 9 digit number? Thanks for your time.
Otto

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
what is a scientific notation#?	hisham	Excel Discussion (Misc queries)	4	February 16th 10 06:34 PM
Scientific notation of CSV	FASTWRX	Excel Discussion (Misc queries)	4	October 25th 07 12:59 AM
Scientific notation	Biocellguy	Excel Worksheet Functions	2	May 24th 07 07:48 PM
scientific notation	T.Reisz	Excel Discussion (Misc queries)	4	June 12th 06 01:59 PM
Scientific notation	Clive	Excel Discussion (Misc queries)	2	February 8th 05 11:38 PM

All times are GMT +1. The time now is 01:06 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us