Points Formula

[m_789]

Hey guys any one that can work this out but im trying to get a fomula that wil convert a % into a number for example

if i got 95% in column a1 i want it to say in a2 95

if 1% to say 1
if 2% to say 2 and on...

[Paul]

Hi m_789,

If the value in A1 is an actual numeric percentage, e.g. 95% = .95, but formatted as a percent, then in A2 you could simply use

=A1*100

And format as a number with 0+ decimal places.