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

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

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