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
 

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

Top