Prev: If condition with text
Next: Time in Seconds Only
From: newuser on 6 May 2010 10:36
everytime i enter a number into a cell excel converts it into a date i need
that data to stay as entered
From: Jacob Skaria on 6 May 2010 10:39
Select the range. From menu select Format>Cells> 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
From: Gord Dibben on 6 May 2010 18:42
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
<newuser(a)discussions.microsoft.com> wrote:

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

 | 
Pages: 1
Prev: If condition with text
Next: Time in Seconds Only