functions do not calculate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I input =CONCATENATE(E51,E52,E53) in cell E50 and it appears as text as
entered. Why will it not return a value? I have all cells formatted as text.
 
Try the following...

1) format the cell as 'General'

2) click in the 'Formula Bar' and press 'Enter' or re-enter the formula

Hope this helps!
 
By formatting the cell containing the formula as text you have made Excel
think the formula is just a bunch of characters. Try formating the cell
containing the formula as general.
 

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

Fill handle formula 9
Automatically Color Autoshape and Autoshape Naming 2
Excel function glitch? 1
SMALL function 7
Repeating a formula 3
Literal based on Week end 3
Currency format 8
Lookup in multiple columns 7

Back
Top