Excel Decimal Places

H

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?
 
F

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)
 
Top