Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On Thu, 5 Jan 2006 08:01:02 -0800, "Sloth"
wrote: Oops your right. It should have been 1230 or 1235. Thanks everyone for your suggestions. There is still the issue of formatting with significant digits when the number is greater than 10^sigdigits. For example 1234.5 with three significant digits should be 1230 and I don't know how to format it that way. While you can, with formatting, display 1235, 1235 has four significant digits, and you are specifying three. --ron |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |