how can i stop excell from formatting numbers into dates?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shad - 28 Sep 2004 02:21 GMT

when i type 1-3, it auto formats and writes 1-Mar, as the date, but i want to
leave it as 1-3

Reply to this Message

Dave Peterson - 28 Sep 2004 02:40 GMT

format the cell as text first (format|cells|number tab|Text)

or start with an apostrophe:

'1-3

> when i type 1-3, it auto formats and writes 1-Mar, as the date, but i want to
> leave it as 1-3

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message

dave22q - 28 Sep 2004 03:08 GMT

use custom opion in format cells to provide the dash, eg # - #
would translate input 14 to display of 1 - 4 and still allow calcs
using the value which still is 14

Signature

dave22q

Reply to this Message

dave22q - 28 Sep 2004 03:09 GMT

use custom option in format cells to provide the dash, eg # - #
would translate input 14 to display of 1 - 4 and still allow calc
using the value which still is 1

Reply to this Message

- 28 Sep 2004 04:33 GMT

type it as

'1-3

or change the format of the cell to text...

> when i type 1-3, it auto formats and writes 1-Mar, as the date, but i want
> to
> leave it as 1-3

Reply to this Message