two significant numbers in colums

[chicopee]

Is there a quick way to change many numbers after decimal points to two significant numbers within a column?

 

[MintJulep]

Do you want to CHANGE the values, or just display a set number of significant digits?

 

[IRstuff]

Not sure if I understand your question. There's Increase Decimal and Decrease Decimal on the Formatting toobar.

Or are you looking for a set number of significant digits? If so, there are some old threads on this subject:
thread770-39236 is one

TTFN

FAQ731-376

 

[StephenA]

To truncate the number to say 2 decimal places use =TRUNC(Cell, 2).

Add a column, use TRUNC to create the truncated number and then Copy and Paste Special to get the truncated number into the original column. Delete the added column.

Stephen Argles
Land & Marine

http://www.landandmarine.com

 

[surfer200]

Choose range, then cells format with right clic/number/choose option....that´s all

 

[IDS]

To truncate the number to say 2 decimal places use =TRUNC(Cell, 2).

But usually (if you want to change the actual number, rather than how it is displayed) you will want to round, rather than truncate, so use = ROUND(Cell,2)


Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[zelgar]

One way is using the following formula:
=round(cell,INT(# Significant digits - log(cell))

this formula will work for both normal numbers and decimals