Posted to sci.electronics.design,microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions

WayneL[_2_] WayneL[_2_] is offline

external usenet poster

Posts: 5

Keeping the exponent at a fix value in Excel

Hi

When formatting in Scientific, how can you keep the exponent constant and
allow the decimal point to move?
For example

If I have:
6.647E-03
1.741E-02
8.378E-02

How do I ensure that Excel keeps the E to E-3 and adjust the decimal point?

Cheers

WayneL

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
Keeping the exponent at a fix value in Excel	WayneL	Excel Worksheet Functions	7	January 9th 06 04:58 PM
Keeping the exponent at a fix value in Excel	WAYNEL	Excel Discussion (Misc queries)	1	January 9th 06 03:40 PM
Keeping the exponent at a fix value in Excel	WAYNEL	Excel Worksheet Functions	1	January 9th 06 03:40 PM
Keeping the exponent at a fix value in Excel	WAYNEL	Excel Discussion (Misc queries)	0	January 8th 06 06:05 PM
Keeping the exponent at a fix value in Excel	WAYNEL	Excel Worksheet Functions	0	January 8th 06 11:11 AM

All times are GMT +1. The time now is 11:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us