Rounding Cell value in the same cell

[Airbisk]

Hi,

If I enter a value into a cell I want that value to be rounded up to the next hundred (e.g 530 becomes 600, 201 becomes 300, 998 becomes 1000 etc)

Can esily be down if I had another colum and used ROUNDUP but is there a way for formatting a cell to automatically change it when entered?

Thanks

 

[SkipVought]

Hi,

Not without VBA code.

This is not a FORMAT issue. You actually CHANGE the value, from one value to another. FORMAT changes nothing. The underlying value is unchanged; only the DISPLAY changes.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[Airbisk]

Thanks for the response Skip - will use some code if required