View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SKJ18 SKJ18 is offline
external usenet poster
 
Posts: 1
Default How do i remove the auto date function from a cell to allow # rang

All i want to do is type 1-10 in a cell as a number range not a date but it
always turns into jan-10 or 1/10/08

i dont want a date i want 1 thru 10 but would rather not have that much
space taken up.