View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default how to change input

Either preformat the cell as TEXT or precede the entry with an apostrophe:
'10-20. The apostrophe will not be displayed in the cell.

--
Biff
Microsoft Excel MVP


"general question" <general wrote in
message ...
when i put in 10-20 in a cell excel automaticaly changes it to 20
october...i
was wonderig how do i change it