Custom # format

  • Thread starter Thread starter jstalin
  • Start date Start date
J

jstalin

Hello,

I would like to display a number * 100, a percentage w/o the percent
sign. For example, if I type in .55 I want the sheet to display the
number as 55. How can I do this?

Thanks
 
I don't think you can.

Can you just type 55 and use A1/100 in subsequent formulas?

Or use a helper cell to display what you want?
 
Back
Top