Number format in formula with text

Excel_user_MM

New member
Joined
Aug 27, 2013
Messages
2
Reaction score
0
Points
0
How do I get the latter sum of this formula to return the value in percentage, not as a decimal number:

="No of girls: "&(SUM(AT2:AT260))&" / % girls:"&((SUM(AT2:AT260)/(SUM(AS2:AS260))))

I.e. as result I would want:
No of girls: 3 / % girls: 43 %

NOT
No of girls: 3 / % girls:0.428571428571429

Is it even possible?

Thanks folks!
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Try:

="No of girls: "&(SUM(AT2:AT260))&" / % girls:"&TEXT((SUM(AT2:AT260)/(SUM(AS2:AS260))),"0.###%")
 
Top