Well I'll be....

Put the cursor in the cell. Move focus to the Formula box, move to the
first position (I see no quote/apostrophe) and press backspace. This worked
for a formula that was not recognized as a formula in a cell formatted as
text. Maybe it will help you.
Good luck.



"MCC" wrote:

This is a very strange error that I have not seen before and I use excel all
day every day. After a save, one column of my spreadsheet immediately went to
bottom vertical alignment and added what effectively was 2-3 lines above the
text (eg., it respaced all of my rows as if there were 4 lines in that one
box). I have tried reformatting the column, pasting the format in to no
avail. I have gone numerous times to the cell format box under the format
menu and changed things, but the format in the actual cells will not change.
It is as if the column were protected but all sheet and cell protections are
off. Has anyone seen this and can you help?