how can i stop excell from formatting numbers into dates?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

when i type 1-3, it auto formats and writes 1-Mar, as the date, but i want to
leave it as 1-3
 
format the cell as text first (format|cells|number tab|Text)

or start with an apostrophe:

'1-3
 
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
 
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
 
Back
Top