Data entry problem
 

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.

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.

Data entry problem
 

I hit send before I added...

and format for fractions.

OR

type single quote ' then 1 / 12

--
HTH,
Bernie
MS Excel MVP


"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
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.

Data entry problem
 

Thanks for the help!

Matt

"Bernie Deitrick" wrote:

I hit send before I added...

and format for fractions.

OR

type single quote ' then 1 / 12

--
HTH,
Bernie
MS Excel MVP


"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
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.