Thread: cell format
View Single Post
  #1   Report Post  
Terry
 
Posts: n/a
Default cell format

I set up cell format as text before I type any data.

I have a samples with ID 9920-2, 9920-10, 9920-15, 9920-18,...
However if I push "Enter" after typing ID, Excel change 9920-2 and 9920-10
to Feb-20 and Oct-20 without even ask do I wnat to change format. ID after
9920-15 remain the same.

Can anyone tell me how to make Excel stop changing my format, and just keep
the format I have set up.