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
 
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.
 
Top