how do i stop excel from converting numbers entered into a date

N

newuser

everytime i enter a number into a cell excel converts it into a date i need
that data to stay as entered
 
J

Jacob Skaria

Select the range. From menu select Format>Cells> and forma that to General.
 
G

Gord Dibben

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
 
Top