G Guest Jun 13, 2006 #1 I am trying to enter the value 1-5 in a cell it and keeps auto changing into the date! how do i stop this?
I am trying to enter the value 1-5 in a cell it and keeps auto changing into the date! how do i stop this?
N Nick Hodge Jun 13, 2006 #2 James Pre-format the cell as text (Format>Cells...Text) or prefix with a single apostrophe '. It won't show but will stop the conversion -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk (e-mail address removed)
James Pre-format the cell as text (Format>Cells...Text) or prefix with a single apostrophe '. It won't show but will stop the conversion -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk (e-mail address removed)
D David Biddulph Jun 13, 2006 #3 James said: I am trying to enter the value 1-5 in a cell it and keeps auto changing into the date! how do i stop this? Click to expand... Format the cell as text before you enter the value. The alternative is to precede the value with an apostrophe.
James said: I am trying to enter the value 1-5 in a cell it and keeps auto changing into the date! how do i stop this? Click to expand... Format the cell as text before you enter the value. The alternative is to precede the value with an apostrophe.
