Alex

guess it depends on what you want to do with the value in the cell. If you
just want to display it, you could multiply the value by 100 and reduce the
decimal places shown to 1.

So =0.055321*100 = 5.5321 and reduce the decimal points to 1

Regards

Trevor


"Alex" wrote in message
...
I have percentages of a total that I don't want to display
with the percent sign, but I want them to be in that
annotation.

For example:
Current Cell
.055321
Percentage Format
5.5%
Objective
5.5

How can I use custom cell formatting or programming to
multiple given numbers by 100?