Posted to microsoft.public.excel.misc

elwilliamson elwilliamson is offline

external usenet poster

Posts: 2

Can I format numbers using engineering notation in excel?

Is there a way to format numbers in excel in engineering format where the
exponent is always a multiple of 3?

Examples
2.6e3
34.7e-9
But not 3.47e-8

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
How to display result of calculations in engineering notation?	Peter_hph	Excel Discussion (Misc queries)	1	December 26th 06 01:02 PM
engineering notation in excell	berty239	Excel Worksheet Functions	1	November 28th 06 05:10 PM
Engineering format	nsv	Excel Discussion (Misc queries)	0	May 23rd 06 09:29 AM
I wish to display numbers in engineering format (exponents * 3).	engineer2	Excel Discussion (Misc queries)	1	December 1st 05 12:03 AM
displaying numbers in engineering notation	Joshua Wong	Excel Discussion (Misc queries)	5	January 31st 05 03:50 PM

All times are GMT +1. The time now is 03:00 PM.

About Us

"It's about Microsoft Excel"