| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format cells number to 3 significant figures??
Hi,
Is it possible to format cells so that Excel shows the data to 3 significant figures? (without having to introduce a formula in the cell) the best I can get is using my custom format # ##0.### which isn't exaclty what I'm looking for, and is also annoying because it always shows the ".", so "100" always displays as "100." |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to display results to certain number of significant figures | Excel Discussion (Misc queries) | |||
| Automatic formatting of Significant Figures .... | Excel Discussion (Misc queries) | |||
| Rounding/Significant figures | Excel Worksheet Functions | |||
| How to calculate/properly display significant figures ending in 0 | Excel Worksheet Functions | |||
| Significant figures (not decimal places) | Excel Worksheet Functions | |||
Threaded Mode
