View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
BS BS is offline
external usenet poster
 
Posts: 10
Default cell format - can not change

I am currently experiencing something similar. Excel just does not always
want to do what one asks it to do.

I had a blank cell set to text, now no formula entered in that cell is
recognized as a formula.


"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?