ExcelBanter - cell formatting in excel - more than 1 character at a time

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - cell formatting in excel - more than 1 character at a time (https://www.excelbanter.com/excel-discussion-misc-queries/256757-cell-formatting-excel-more-than-1-character-time.html)

patgo37

cell formatting in excel - more than 1 character at a time

all cells in excel 2003 are now accepting only 1 character, alpha or numeric

when I go to type 2003 , for instance, the 2 shows, but then when I try to
add the 0, the 2 disappears.

All times are GMT +1. The time now is 05:23 PM.