Mike - followed your instructions, however, when I type 1.23 in after
pre-formatting the cell, it shows as 123.00%

"Mike Rogers" wrote:

hmaze

Formate the cell as a percentage BEFORE you have the data entered and it
will do what you want.

FormatecellpercentageOK

Mike Rogers

"hmaze" wrote:

All:

I need the user to type in the percentage as: one dot two three % (1.23%)
and the cell should show 1.23% but for calculations it should use 0.0123 -
can I do this in custom formatting? Thank you.