Format a cell as a percentage without showing "%"

  • Thread starter Thread starter Matt T
  • Start date Start date
M

Matt T

I've got a worksheet made up of linked data from other
worksheets. The source worksheet contains the raw decimal
percents, ie .189 and I need to show this in my document
as 18.9

I have looked at multiplying the row by 100 but I'd like
to avoid this if possible. Is there a way to format a
cell as a percent but hide the % symbol?
 
Instead of multiplying the entire row by 100, how about just adjusting the
linking formula to multiply the individual cell?

=Sheet2!$A$6*100
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I've got a worksheet made up of linked data from other
worksheets. The source worksheet contains the raw decimal
percents, ie .189 and I need to show this in my document
as 18.9

I have looked at multiplying the row by 100 but I'd like
to avoid this if possible. Is there a way to format a
cell as a percent but hide the % symbol?
 
Back
Top