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

I set up my cell format as "text" format before I type name of sample ID
(9920-2, 9920-8, 9920-15, ...).
However, for 9920-2 and 9920-8, when I push "Enter" Xxcel changes my format
from text to date and become Feb-02 and Aug-02. 9920-15 and those after
remain the way I have set up.

Can anyone tell me how to make Excel stop changing my format and just use
text format I have set up.