Thread: Format a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tia Tia is offline
external usenet poster
 
Posts: 64
Default Format a cell

I have an excel spreadsheet that I use to track data. When I went to enter
the data , 10/50, into the cell, it is changed to Oct 50. It is formatted
the same as previous cells and they don't make the change. I tried changing
the format to allow fractions, but then it changes it to 1/5. Does anyone
know how to fix this so that it reads the 10/50???? Thanks for any advice
that can be given!