automatic number change

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When i enter "3-4" into a cell, excel changes to 38780. i tried to format
cell but it does not help. it occurs when i type in 12-13 and it changes to
39064. what is going on? how can i change this? i am using office 2003
with current updates.
thanks
 
dohoon said:
When i enter "3-4" into a cell, excel changes to 38780. i tried to format
cell but it does not help. it occurs when i type in 12-13 and it changes to
39064. what is going on? how can i change this? i am using office 2003
with current updates.
thanks
Click to expand...

Hi Dohoon,

I think excel changes your typing to exceldateformat. Maybe you can try
to format the Cell to Text you enter 12-13 or 3-4. I think it will stay
that way then. It is important that you do the formating befor you
enter the text.

Regrads,
Bondi
 
Hi Bondi,

Thank you for your post. I've tried to format the cell before and after
entering in it but it does not work any more suggestions? anyone?

TIA
 
dohoon said:
Hi Bondi,

Thank you for your post. I've tried to format the cell before and after
entering in it but it does not work any more suggestions? anyone?

TIA
Click to expand...

Hi,
Try to put a ' infront of you text. Like:

'3-4

Regards,
Bondi
 
Back
Top