View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
fkistner
 
Posts: n/a
Default type in 4-7 changes to 38814

Thank you --- I was going crazy! Have a great day!
--
flojoe


"Gary''s Student" wrote:

Excel thinks you are entering dates:


Use the single quote (apostrophe):

'4-7
--
Gary's Student


"fkistner" wrote:

Help! I am typing into cells numbers like 0-3, 4-7, 8-15, 16-30 and the 4-7
& 8-15 turn into numbers like 38814 --- I have looked at the formatting and
it is the same as the 0-3, yet it automatically changes to something strange
like 38814 --- what is going on? Thanks!
--
flojoe