the reason you see the formula and not the result of the formula is because you have the cell formatted as text. change the format to general
hth
kevin
This is a discussion on concatenate formula showing as formula, not text within the Excel Questions forums, part of the Question Forums category; I have the following formula: =CONCATENATE(B28,0) In B28 is the following text(formated as text):000143 so I want the result to ...
I have the following formula:
=CONCATENATE(B28,0)
In B28 is the following text(formated as text):000143
so I want the result to be: 0001430
I have used the fx button to make sure syntax is correct and cell is formated as text, but we only see the formula, not the result.
What can we do?
the reason you see the formula and not the result of the formula is because you have the cell formatted as text. change the format to general
hth
kevin
...and hit F2.Originally Posted by kskinne
Like this thread? Share it with others