Thread: how do i stop excel from converting numbers entered into a date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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 With QuoteReply With Quote