| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i stop excel from converting numbers entered into a date
everytime i enter a number into a cell excel converts it into a date i need
that data to stay as entered |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i stop excel from converting numbers entered into a date
Select the range. From menu select FormatCells and forma that to General.
-- Jacob (MVP - Excel) "newuser" wrote: everytime i enter a number into a cell excel converts it into a date i need that data to stay as entered |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i stop excel from converting numbers entered into a date
Post some examples of the numbers if Jacob's re-format does not fix it.
If you enter 5/5 or 5-5 Excel will treat as a date. Those types of data must have pre-formatting of TEXT or precede the number with an apostrophe. Gord Dibben MS Excel MVP On Thu, 6 May 2010 07:36:16 -0700, newuser wrote: everytime i enter a number into a cell excel converts it into a date i need that data to stay as entered |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop from converting numbers (e.g 3-30) into dates | New Users to Excel | |||
| How do I stop Excel from converting a numerical entry to a date? | Excel Discussion (Misc queries) | |||
| Can stop excel from converting value to date? | New Users to Excel | |||
| Stop numbers converting to dates. | Excel Worksheet Functions | |||
| How do I stop Excel from changing numbers into a date? | Excel Discussion (Misc queries) | |||
Hybrid Mode
