Custom # format

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
 
D

Dave Peterson

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?
 
Top