| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format significant digits
Is there a way to apply a custom format that will only display a certain
number of significant digits? For instance for 3 significant digits Input Values-Display As 0.12345-0.123 or .123 1.2345-1.23 12.345-12.3 123.45-123 1234.5-1230 or 1234 I think I could make a formula that could do this, but I would rather keep the precision. I just want to adjust the displayed precision. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| " / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
| " / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
| why does currency format change to number format? | Excel Discussion (Misc queries) | |||
| Keep custom format in new worksheet | Excel Discussion (Misc queries) | |||
| How to format a date to a different format | Excel Discussion (Misc queries) | |||
Threaded Mode
