| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Remove function?
We just got Microsoft Excel '07 and I'm trying to enter a simple '1-5' type
of data and it keeps converting it to a date. How do I format the cell to leave what I type alone? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Remove function?
Pre-format as Text or precede the entry with an apostrophe.
The apostrophe won't show in the cell. Gord Dibben MS Excel MVP On Thu, 31 Jul 2008 08:35:22 -0700, Brooke wrote: We just got Microsoft Excel '07 and I'm trying to enter a simple '1-5' type of data and it keeps converting it to a date. How do I format the cell to leave what I type alone? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove a Function | Excel Discussion (Misc queries) | |||
| Remove function | Excel Discussion (Misc queries) | |||
| How do your remove ROUND function? | Excel Worksheet Functions | |||
| function to add or remove | Excel Worksheet Functions | |||
| How do I remove a function? | Excel Worksheet Functions | |||
Linear Mode
