making number percentage using

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

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.

resolvedResolved · Low Priority · Version 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:

Bring up formatting dialog box

Ctrl+1

View all Excel hints and tips


Server loaded in 0.08 secs.