Only the Concatenate Fx shows in cell.

October 12, 2010 at 11:48:06
Specs: Windows 7
Only the Concatenate function will show in the cell, not the result. Any tips?

See More: Only the Concatenate Fx shows in cell.

Report •

#1
October 12, 2010 at 12:16:47
Check on the formula bar, does your formula have a space before the equal sign?

MIKE

http://www.skeptic.com/


Report •

#2
October 12, 2010 at 12:24:31
If the format of the cell is stuck on Text (which Excel has been known to do) the formula will show and not be treated as a formula.

Sometimes even Format...Cells...Number (or whatever) won't change it.

Try another cell and see if you can get the formula to work. If so, select that cell, click the Format Painter icon and then click the troublesome cell.

Let us know if that works.


Report •
Related Solutions


Ask Question