format a percentage figure


B

bill

Hi to everyone

i have a worksheet where i am retrievine data from access

so i bring this data to another worksheet be equation.

the number is already as a percentage in the database but
it appears like 9,56 (it really means 9,56%)

in the worksheet i want to have that number but if i am
trying to format it as a percentage it change it to 956 %

There is anyway to bring it witha equation but manually
to format it and appears like 9,56 %

regards bill
 
Ad

Advertisements

Ad

Advertisements

D

Dave Peterson

Another option:

put 100 in an empty cell.
copy that cell
Edit|copy

Select your range of "percentages"
Edit|paste special|check divide

Format that range as a percentange

clean up that helper cell.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top