| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel - I type 9-6 in cell and it automatically changes to 9 June
When I type numbers into an excel cell they automatically change to a date
and I want the numbers not a date. How do I save my own entry? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Excel - I type 9-6 in cell and it automatically changes to 9 June
Format the cell as Text prior to entering the text, or precede
the text with an apostrophe ('). The ' will not show in the cell, but will in the formula bar. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "fevans" wrote in message ... When I type numbers into an excel cell they automatically change to a date and I want the numbers not a date. How do I save my own entry? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Excel automatically insert current date in a cell? | Excel Worksheet Functions | |||
| can excel automatically enter the date data in a cell was entered | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| In excel, can I format a cell to automatically take the curser to. | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
