View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default Data entry problem

Matt,

Type =1/12

HTH,
Bernie
MS Excel MVP


"Matt_Training" wrote in message
...
I am trying to enter "1 / 12" into a cell, but every time I do this the
computer coverts the cell to a date and changes the values to 01-Dec. I
looked through the automatic edit mode and can not find a way to change it.
I need to find a way to change it so that I can put any number before or
after the slash, with spaces between. I am using Microsoft Office Excel
2007.