| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Signifcant digits
I had a search as I was sure that this would have been answered, but didn't
really find what I needed. How can I display 3,456 as 3,460 (so to 3 significant digits) without changing the value of the cell (as would happen with the round function). Thanks in advance. Daniel |
|
#2
|
|||
|
|||
|
On Fri, 26 Aug 2005 08:53:47 -0700, "Daniel Bonallack"
wrote: I had a search as I was sure that this would have been answered, but didn't really find what I needed. How can I display 3,456 as 3,460 (so to 3 significant digits) without changing the value of the cell (as would happen with the round function). Thanks in advance. Daniel I do not believe that is possible. How about scientific format: 0.00E+00 would be 3.46E+03 Another option would be to use the ROUND function for display, but use a different column (which could be hidden) for performing your calculations. --ron |
|
#3
|
|||
|
|||
|
Thanks Ron
"Ron Rosenfeld" wrote: On Fri, 26 Aug 2005 08:53:47 -0700, "Daniel Bonallack" wrote: I had a search as I was sure that this would have been answered, but didn't really find what I needed. How can I display 3,456 as 3,460 (so to 3 significant digits) without changing the value of the cell (as would happen with the round function). Thanks in advance. Daniel I do not believe that is possible. How about scientific format: 0.00E+00 would be 3.46E+03 Another option would be to use the ROUND function for display, but use a different column (which could be hidden) for performing your calculations. --ron |
|
#4
|
|||
|
|||
|
As Ron pointed out, there is no sigfig format, but if you will be
handling a lot of numbers, you may prefer a formula to round to specified number of figures http://groups.google.com/group/micro...244c8f41e91025 to the Round function that rounds to a specified number of decimal places. Jerry Daniel Bonallack wrote: I had a search as I was sure that this would have been answered, but didn't really find what I needed. How can I display 3,456 as 3,460 (so to 3 significant digits) without changing the value of the cell (as would happen with the round function). Thanks in advance. Daniel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mod 10 & 11 | Excel Worksheet Functions | |||
| Isolate the last 4 digits in a cell | Excel Discussion (Misc queries) | |||
| Help - Any number longer than 12 digits turns to scientific and ro | Excel Discussion (Misc queries) | |||
| Concatenate function - keeping "displayed" extra digits | Excel Discussion (Misc queries) | |||
| Least number of digits in Y-axis labels | Charts and Charting in Excel | |||
Linear Mode
