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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top