View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
hmaze hmaze is offline
external usenet poster
 
Posts: 13
Default Format Percentage

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.