Menu

Significant figures (not decimal places)

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Frank Kabel

Posts: n/a

Default

Hi
see:
http://www.mcgimpsey.com/excel/formulae/sigfigs.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Gene Solomon" <Gene schrieb im
Newsbeitrag ...
Is there a way to display numbers with 3 significant figures? For
instance,
display 1367 as 1370, 14621 as 14600, and .02637 as .0264.

I'm trying to find a way to take a column of data, and then display
it with
3 sig figs. Will any functions or macro help me out?

Thanks.

Reply With Quote

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 do I override fixed decimal place settings in EXcel 2003?	jroyv	Excel Worksheet Functions	2	February 11th 05 06:07 PM
ROUND DATA TO 2 DECIMAL PLACES	roy in sunbury	New Users to Excel	1	January 12th 05 03:33 AM
decimal point override does not work	Sam Brauen	Excel Discussion (Misc queries)	0	January 6th 05 05:29 PM
Format a worksheet to carry out all calculations to 2 decimal plac	Phill Barrett	Excel Discussion (Misc queries)	2	January 5th 05 01:07 PM
Decimal places in Excel 2003	EXCELNCBOY	Excel Worksheet Functions	6	November 5th 04 03:39 PM

All times are GMT +1. The time now is 11:30 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement