I have a spreadsheet that has a number of cells with number - i need to
format them as % but if you go to the format cell option then the numbers are
multipled by 100 before changing to %. I need the numbers to stay the same
value.

e.g.

39.5 = 39.5% not 3950%.

How do a format these cells without going into each one and add the %.

Use a custom format of: 0.0"%"

--
Regards,
Fred


"Penny" wrote in message
...
I have a spreadsheet that has a number of cells with number - i need to
format them as % but if you go to the format cell option then the numbers are
multipled by 100 before changing to %. I need the numbers to stay the same
value.

e.g.

39.5 = 39.5% not 3950%.

How do a format these cells without going into each one and add the %.

Thank you Fred that is great.

I have managed to do it on one worksheet but can I store it in the custom
Format so it can be used on different worksheets. If so how.

Penny

"Penny" wrote:

I have a spreadsheet that has a number of cells with number - i need to
format them as % but if you go to the format cell option then the numbers are
multipled by 100 before changing to %. I need the numbers to stay the same
value.

e.g.

39.5 = 39.5% not 3950%.

How do a format these cells without going into each one and add the %.

In the version of Excel I use, previously specified custom formats are
automatically stored. Typically they are at the bottom of the list. Try looking
there.

--
Regards,
Fred


"Penny" wrote in message
...
Thank you Fred that is great.

I have managed to do it on one worksheet but can I store it in the custom
Format so it can be used on different worksheets. If so how.

Penny

"Penny" wrote:

I have a spreadsheet that has a number of cells with number - i need to
format them as % but if you go to the format cell option then the numbers are
multipled by 100 before changing to %. I need the numbers to stay the same
value.

e.g.

39.5 = 39.5% not 3950%.

How do a format these cells without going into each one and add the %.