Change the col format to either general or number. Then click inside the top
cell with your formula, press ENTER*, then copy down.

*This re-enters your formula. This re-entering needs to be done.
Re-formatting the col alone doesn't re-activate.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
wrote in message
ups.com...
I have a spreadsheet with columns A through K filled with text
formatted cells. What I want to do is to Concatenate cell C and D by
inserting a column to the left of C and placing a concatenate formula
in Cell a2 and copying down.

when I do this, all I get is the formula in the cell. In looking at
the format of the inserted column it is formatted as text
automatically.

First of all, should it always pick up the format from the cell to the
right of it when inserted? Secondly, shouldn't it still place the
result of my concatenate formula into the cells even though it is
formatted as text cells?

Thanks so much for your help.