How do I display 6-8 in Excel without it becoming 8 June 2008?
F Franz Erhart Jun 30, 2008 #2 Solution 1: format the cell with "text" Solution 2: prefix 6-8 with "'" eg '6-8