LinkBack URL
About LinkBacks
Please see below. C1 is created using the following formula: C1 = A1&" "&"("&B1&")"
Within C, how can I retain the percentage format?
A1 = 336
B1 = 23.9%
C1 (desired result) = 336 (23.9%)
C1 (actual result) = 336 (0.238636363636364)
Thank you!!
Please see below. C1 is created using the following formula: C1 = A1&" "&"("&B1&")"
Within C, how can I retain the percentage format?
A1 = 336
B1 = 23.9%
C1 (desired result) = 336 (23.9%)
C1 (actual result) = 336 (0.238636363636364)
Thank you!!
maybe
=A1&" "&"("&TEXT(B1,"00.0%"&")")
Maybe this will work for you:
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thank azumi and newdoverman! The formula worked perfectly!!!
=A1&" "&"("&TEXT(B1,"0.0%"&")")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks