Thanks:  0
Likes:  0

1. I am trying to format selected cells to x.xx%. Using the Percent Style, "%", button doesnt format 8.9 to 8.90%, it formats it to 890%.

Any suggestions? I am trying to use this in a format procedure.

Thanks!

2. I don't know why this is but if you format the cell first, then type in 8.9 you will get 8.90%. If you type the number in first them format the cell it will show 890%. You can go back and retype your number and it will be correct........

Denny

[ This Message was edited by: kinkyparamour on 2002-04-27 20:23 ]

3. That's right!
8.9 is 890%
and 8.9% is .089
When you format it as % first then what ever you enter Excel multiplies it by 100.

You can check these out by formatting the number to GENERAL format .. you wil get 890% is 8.9, and 8.9% is 0.089

HTH

4. i've had this happen to me numerous times. if your spreadsheet has a ton of numbers that are like this (mine did) you can do one of two things, either select the whole column and go edit, find, search by 00, replace and leave the replace field blank, it will automatically take out the extra two zero's and still keep it as a number and a percentage. you can also type in a seperat cell 100, copy that, select the column again, right click, paste special, in the middle section of that window say divide. that will also take care of it

5. I have tried to do some of the mentioned above to no avail. I am trying to format a selection using code to format X.X as X.XX%.

Does anyone know of any code that I can do this with?

Thanks for the suggestions.

Maybe time has passed this question light years, but new Excel users may have same problem. Personally I came up with same problem with imported numbers which I had to format 0.00 %.

I solved it by using Custom Number Format: In Format Cells Dialog / Number / Custom typing 0.00 "%".

If somebody knows better way, so let me know.

Brgds Sir Vili.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•