Excel: Truncate issue with formula

Hello Experts!

Does anyone know how to properly write a formula that will show the actual format of the the two cells being combined?

Please see attached file. Example.xlsx
Maliki HassaniAsked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
=A3&" "&TEXT(T3,"0.00%")
should work.
0
 
jppintoConnect With a Mentor Commented:
Use this formula:

=A3&" "&TEXT(T3,"0,00%")

jppinto
0
 
jppintoCommented:
Please check the working example...
Example-1-.xlsx
0
 
Maliki HassaniAuthor Commented:
Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.