Chris has attended:
Excel Advanced course
Making a number in to a percentage when using Ampersand.
Hi There
I run a report each week where I have to input the percentage sales for each buyer in to two sections - once for the formular and the other in "wordy" form. I am getting bored of entering the data twice, and recall I can use the Ampersand to draw the formular percentage in to the Wordy bit.
My forumlar so far is as follows:
="US2 @ "&A19&" sales"
This shows A19 in decimals - how do I make it in to a percentage?
I think it is something like the below - but am stuck at the HELP bit!
="US2 @ "&TEXT(A19,HELP)&" sales"
Many thanks
Chris
RE: Making a number in to a percentage when using Ampersand.
Hi Chris, thanks for your query. Try:
="US2 @ "&TEXT(A19,"0%")&" sales"
Hope this helps,
Anthony