Need help in forcing number that wants to stay in Sci. Notation fo

Posted to microsoft.public.excel.worksheet.functions

phil

external usenet poster

Posts: 201

Need help in forcing number that wants to stay in Sci. Notatio

Bernd,

That worked BEAUTIFULLY!

Thank You.

"Bernd" wrote:

Hi,

Does

=TEXT(A1,"0")

help?

Regards,
Bernd

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
Number Formatting/Scientific notation	Patrice	Excel Discussion (Misc queries)	1	January 19th 07 08:55 PM
Forcing scientific notation to a specific power	C.O.	Excel Discussion (Misc queries)	1	September 19th 06 11:03 PM
Need to indirectly reference columns 26 using A1 notation based on numeric column number- how to?	KR	Excel Worksheet Functions	5	October 26th 05 07:08 PM
HOW TO GET THE NUMBER ICONS TO STAY AT THE SIZE NEEDED INSTEAD OF.	alibob	Excel Discussion (Misc queries)	1	May 26th 05 12:34 PM
convert scientific notation to a number	Peter	Excel Discussion (Misc queries)	1	January 4th 05 07:08 PM

All times are GMT +1. The time now is 06:17 PM.

About Us