ExcelBanter - Excel - I type 9-6 in cell and it automatically changes to 9 June

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Excel - I type 9-6 in cell and it automatically changes to 9 June (https://www.excelbanter.com/new-users-excel/89775-excel-i-type-9-6-cell-automatically-changes-9-june.html)

fevans

Excel - I type 9-6 in cell and it automatically changes to 9 June

When I type numbers into an excel cell they automatically change to a date
and I want the numbers not a date.
How do I save my own entry?

Chip Pearson

Excel - I type 9-6 in cell and it automatically changes to 9 June

Format the cell as Text prior to entering the text, or precede
the text with an apostrophe ('). The ' will not show in the cell,
but will in the formula bar.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"fevans" wrote in message
...
When I type numbers into an excel cell they automatically
change to a date
and I want the numbers not a date.
How do I save my own entry?

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