| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display results to certain number of significant figures
How do I display results to a fixed number of significant figures?
25100 display as 25000 250 display as 250 25 display as 25.0 2.5 display as 2.50 0.25 display as 0.250 Etc. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to display results to certain number of significant figures
Simplest way to always display two sig figs is to use scientific notation: 0.0E+0 If you'd rather have a root canal than use exponential notation, search the newsgroups for this issue. Several attempts have been made to use the ROUND and TEXT functions to do what you want. -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=499635 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Number Display | Excel Worksheet Functions | |||
| display actual number or zero, whichever is greater | Excel Discussion (Misc queries) | |||
| Display ONLY fraction portion of number | Excel Discussion (Misc queries) | |||
| Significant figures (not decimal places) | Excel Worksheet Functions | |||
| How do I multiply Column G Totals by a number and display the res. | Excel Discussion (Misc queries) | |||
Linear Mode
