L
landen99
I have a problem with changing the format of a pure number in a cell
formatted as a text. After the type is changed to a number (actually
it's changed to special - 000000), the cell refuses to change until
after the cell is edited (with or without changes) and the ENTER key is
pressed. Is there an easy way around this?
A similar thing happens with a cell has a special enter character.
Editing the cell and pressing enter changes the cell format to word
wrap and to recognize the special character, though the character is
not usually desired. I know how to delete the special characters with
a find and replace, but it illustrates how excel refuses to change the
cell formats until after you edit each cell. That can take a lot of
time with thousands of entries, like the document database that I'm
working with. Any suggestions?
Thanks in advance,
Andy Landen
formatted as a text. After the type is changed to a number (actually
it's changed to special - 000000), the cell refuses to change until
after the cell is edited (with or without changes) and the ENTER key is
pressed. Is there an easy way around this?
A similar thing happens with a cell has a special enter character.
Editing the cell and pressing enter changes the cell format to word
wrap and to recognize the special character, though the character is
not usually desired. I know how to delete the special characters with
a find and replace, but it illustrates how excel refuses to change the
cell formats until after you edit each cell. That can take a lot of
time with thousands of entries, like the document database that I'm
working with. Any suggestions?
Thanks in advance,
Andy Landen