Solved

Excel:  Truncate issue with formula

Posted on 2011-02-10
4
306 Views
Last Modified: 2012-08-13
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
0
Comment
Question by:Maliki Hassani
  • 2
4 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 250 total points
ID: 34865866
=A3&" "&TEXT(T3,"0.00%")
should work.
0
 
LVL 33

Assisted Solution

by:jppinto
jppinto earned 250 total points
ID: 34865894
Use this formula:

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

jppinto
0
 
LVL 33

Expert Comment

by:jppinto
ID: 34865904
Please check the working example...
Example-1-.xlsx
0
 

Author Closing Comment

by:Maliki Hassani
ID: 34865919
Thank you!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question