specify format of a cell with text and data combination

V

vince

When combining text and data in a cell, I loose the format
of the data. How can I specify the format?

As an example, my cell is: ="Growth: "&AN33 but the result
appears as "Growth: 0.12", whereas I would like to
have "Growth: 12%"

thanks for any help

Vince
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Large Discrepencies in Graph Data 0
How to make a VBA Function return a value in percent format 8
scatter plot data point labelling question 5
Paste to excel from word - auto format problem 1
Combining three files when middle file has sections with endnotes 2
Linking data in MS Word into Excel 5
Converting URLs in comments to Markdown-formatted links 2

Top