Posted to microsoft.public.excel.misc

Peter

external usenet poster

Posts: 349

how do i show 3 significant figures

i need to show numbers to 3 significant figures. in one column, the numbers
should show as 5.36, 7.56, 20.8, 47.6, 171, 291, 1070. all to 3 significant
figures, but to different numbers of decimal places. thanks.

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
significant figures	Crystal	Excel Worksheet Functions	14	July 8th 09 07:36 PM
Significant figures as a conditional format	stephenp	Excel Worksheet Functions	3	October 15th 08 10:01 AM
significant figures?	bgarey	Excel Discussion (Misc queries)	15	September 3rd 08 08:01 PM
Automatic formatting of Significant Figures ....	CFD	Excel Discussion (Misc queries)	4	September 22nd 05 11:32 PM
Rounding/Significant figures	cloots	Excel Worksheet Functions	5	September 1st 05 04:03 PM

All times are GMT +1. The time now is 03:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us