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.