Percent format

waderw · Apr 27th, 2002, 09:12 PM

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!

kinkyparamour · Apr 27th, 2002, 09:22 PM

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 ]

Yogi Anand · Apr 27th, 2002, 09:52 PM

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

celeste · Apr 28th, 2002, 01:12 AM

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

waderw · Apr 29th, 2002, 08:32 PM

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.

Sir Vili · Aug 2nd, 2002, 05:03 AM

Hello waderw.

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.

Apr 27th, 2002, 09:52 PM	#3
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	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 __________________ Regards! Yogi Anand, D.Eng, P.E. Energy Efficient Building Network LLC www.energyefficientbuild.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 27th, 2002, 09:12 PM	#1
waderw Board Regular Join Date: Apr 2002 Posts: 85	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!

Apr 27th, 2002, 09:22 PM	#2
kinkyparamour Board Regular Join Date: Feb 2002 Location: Florida Posts: 82	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 ]

Apr 28th, 2002, 01:12 AM	#4
celeste New Member Join Date: Apr 2002 Posts: 7	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

Apr 29th, 2002, 08:32 PM	#5
waderw Board Regular Join Date: Apr 2002 Posts: 85	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.

Aug 2nd, 2002, 05:03 AM	#6
Sir Vili Board Regular Join Date: Jul 2002 Location: Nurmijärvi, Finland Posts: 148	Hello waderw. 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.