Hello --

My user was complaining that entering a percentage in a percentage-formatted
cell was resulting in 100 times the value he entered.

His method of entry was to enter the value in the formula bar while the
target cell was hilighted (does not seem like an efficient way to enter
data) which appears to ignore the cell format: Number Percentage.

But ... the customer is always right.

Is there a way to have the cell formatting apply when cell data entry is via
the formula bar?

Thanks for any help.

Larry Mehl