Excel Concatonation issue

[mart10]

I am using Excel 2003 SP3

I have a concatonation formuala ="CF"&F2&G4 which works by returning CF0123ABCDEF, but I keyed in in error it should have been ="CF"&G2&G4 (ie G2) but this just retuns the actual formula not the results!

I have pasted in same format as the cell that worked, no effect. Cell G2 is fine as are its contents I tried ="CF"&G2&H4 and this worked for instance

weird

 

[SkipVought]

Hi,

Change the Number Format for the cell to GENERAL.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[lionelhill]

If anyone, anywhere, who has any influence over Excel, is reading this. Plleeeeease, this is one of my all-time gripes with an otherwise fine piece of software.

If you are typing a formula in a cell whose format has become set to "text", Excel will recognise that you are typing a formula, and prompt for the parameters the formula requires. But because it is text, you just get the formula as text, which is Really Annoying. Wouldn't it be nice if Excel could do one of the following far more logical things:

(1) not prompt with formula and parameters
(2) offer to change the format to "general"
(3) change the formula silently to general, if this is accepted somewhere in a customise page.