| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Numeric Data Entry problem | Excel Discussion (Misc queries) | |||
| data entry problem | Excel Worksheet Functions | |||
| Data Entry problem | Excel Discussion (Misc queries) | |||
| Data Entry problem | Excel Discussion (Misc queries) | |||
| Data Entry problem | Excel Discussion (Misc queries) | |||
Hybrid Mode
