C CB Apr 17, 2006 #1 Hello All, How do enter "1-2" or "5/8" into a cell without excel turning my entry into a date?
N Nick Hodge Apr 17, 2006 #2 CB Preformat the cell(s) as text (Format>Cells...>Number>Text) or prefix with a single apostophe ('), this will not show but will stop it converting -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk (e-mail address removed)
CB Preformat the cell(s) as text (Format>Cells...>Number>Text) or prefix with a single apostophe ('), this will not show but will stop it converting -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk (e-mail address removed)
