Hiding the percentage sign

[Habari09]

I have a spreedsheet that shows some percentages example( 9.98% and 15.87%) I am needing to find a way to hide the percentage sign so that they just show as 9.98 and 15.87. The problem I am having is that are been worked out as a percentage, so changing the format of the cell does not work.
Can anyone help?

Thanks
Chris

 

[cornflakegirl]

9.98 is 100 times bigger than 9.98%, so you can't do it just by changing the format. You could do it by multiplying the number by 100 and changing the format.

 

[Richard Schollar]

Hi

See this post:

http://www.mrexcel.com/forum/showthread.php?t=297038&highlight=format+Ctrl

 

[cornflakegirl]

Oooh, nice!

 

[Palanikumar]

Select cell you would like to change. Click Data in menu bar select Text to Columns then select ​

Delimited

click next un check all the ​

check box click Others enter %

in the box and Select the none in ​

TextQualifer

click next change the Destination to the Desired cell Click ​

Finish

Read more: http://wiki.answers.com/Q/How_to_re...ithout_changing_values_in_Excel#ixzz1uaq3hbSa​