how do I display the formula result instead of the formula itself.


G

Guest

Using the concatenate function, I get the correct formula result in the
formula window but once I say OK it displays the formula itself on the cell
not the result...I am trying to combine text and numbers (an address) and it
is just not working...HELP!
 
Ad

Advertisements

G

Govind

Hi,

Check the format of the cell having the concatenate function. It would
have been formatted as text.

Regards

govind.
 
G

GerryK

Make sure there are no leading spaces in the formula. I.e.
a blank before the = sign.
 
Ad

Advertisements

F

Frank Kabel

Hi
check if the cell ist formated as 'Text'. Change the format ('Format -
Cell') to 'General' and re-enter your formula
 
You must log in or register to reply here.

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

Diplaying results of a formula instead of the formula itself 1
formula displayed instead of the result ??? 2
Cell displays formula instead of the formula's result 3
CountIf formula results in the formula itself being displayed. 9
View formula result instead of formula 4
How can I display formula values instead of the formula? 10
SUM formula generating formula instead of result. 2
Formulas appear in cell instead of formula result 3

Top