Excel Decimal Places

[Harry]

How can a cell or series of cells be formatted to place
the last 2 numbers enter to the right of the decimal and
not have the entire sheet formatted that way?

 

[Frank Kabel]

Hi
if you don't wnat to use the option 'fixed decimals' this can't be done
with a format. You'll need VBA for this (an event procedure)