ExcelBanter - How do I display 6-8 in Excel without it becoming 8 June 2008?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I display 6-8 in Excel without it becoming 8 June 2008? (https://www.excelbanter.com/excel-discussion-misc-queries/193107-how-do-i-display-6-8-excel-without-becoming-8-june-2008-a.html)

spoordrdr

How do I display 6-8 in Excel without it becoming 8 June 2008?

How do I display 6-8 in Excel without it becoming 8 June 2008?

Franz Erhart

How do I display 6-8 in Excel without it becoming 8 June 2008?

Solution 1: format the cell with "text"
Solution 2: prefix 6-8 with "'" eg '6-8

"spoordrdr" wrote:

How do I display 6-8 in Excel without it becoming 8 June 2008?

All times are GMT +1. The time now is 07:43 AM.