| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i stop the auto format on excel?
I am trying to enter the value 1-5 in a cell it and keeps auto changing into
the date! how do i stop this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i stop the auto format on excel?
James
Pre-format the cell as text (FormatCells...Text) or prefix with a single apostrophe '. It won't show but will stop the conversion -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "James" wrote in message ... I am trying to enter the value 1-5 in a cell it and keeps auto changing into the date! how do i stop this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i stop the auto format on excel?
"James" wrote in message
... I am trying to enter the value 1-5 in a cell it and keeps auto changing into the date! how do i stop this? Format the cell as text before you enter the value. The alternative is to precede the value with an apostrophe. -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop auto creating .TMP files in EXCEL? | Excel Discussion (Misc queries) | |||
| How do you turn off pivot table auto format in Excel? | Excel Discussion (Misc queries) | |||
| Excel should format time down to the hundredth/sec. | Excel Discussion (Misc queries) | |||
| Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) | |||
| Stop excel emedding (opeing in mail format) when outlook is open. | New Users to Excel | |||
Linear Mode
