formatting cells
Depending on what other things you are typing in those cells you could
highlight the range of cells you will be entering data into and format them
as 'text'. That will make sure your 1-19 shows up.
"worduser" wrote:
everytime I enter a 1-19 in a cell, it defaults to jan-19. I then go to the
cell right-click, formatting cells and select General and it gives me a
number 39009. I try again while General is selected and it still defaults to
Date. How can I have set as General number by default
I use excel 2000
|