Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

making number percentage using

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Making a number in to a percentage when using Ampersand.

Making a number in to a percentage when using Ampersand.

ResolvedVersion 2007

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

Excel tip:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.13 secs.