svetlana wrote:
how do i show a rounded number without rounding it
for example:
i need to show a number $754,612 as $754,600, although i
have to use $754,612 in the calculation.

maybe there is a way to program a custom format, but i
know know how.

thank you!
svetlana
The only way I know to do this with a custom format can only handle
rounding the display at the thousands place (or millions and billions).

The custom format to do thousands is:
#,##0,

Someone may prove me wrong, but I don't think custom formats can
handle rounding for hundreds.


Hope that helps,

Matthew