Custom cell format

[AmitV]

Is it possible to format a cell to change a percent value to a numeric value without using the formula cellvalue*100? can I use a custom mask to do so?

 

[RoryA]

If you mean you want to display 5% as 5, then no.

 

[AmitV]

If you mean you want to display 5% as 5, then no.

Thanks Rorya. That is what I meant yes. I will just have to build a macro to do the calculations in the background