two significant numbers in colums
two significant numbers in colums
(OP)
Is there a quick way to change many numbers after decimal points to two significant numbers within a column?
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
two significant numbers in colums
|
RE: two significant numbers in colums
RE: two significant numbers in colums
Or are you looking for a set number of significant digits? If so, there are some old threads on this subject:
thread770-39236: Significant Digits is one
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: two significant numbers in colums
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
www.landandmarine.com
RE: two significant numbers in colums
RE: two significant numbers in colums
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/
RE: two significant numbers in colums
=round(cell,INT(# Significant digits - log(cell))
this formula will work for both normal numbers and decimals