ExcelBanter - How do I stop from converting numbers (e.g 3-30) into dates

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

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

- - How do I stop from converting numbers (e.g 3-30) into dates (https://www.excelbanter.com/new-users-excel/188233-how-do-i-stop-converting-numbers-e-g-3-30-into-dates.html)

Proft

How do I stop from converting numbers (e.g 3-30) into dates

I'm trying to enter records into a spreadsheet. everytime i Try to use a
dash, it converts into a date

Max

How do I stop from converting numbers (e.g 3-30) into dates

Either pre-format the input column as text (via FormatCells)
Or precede the data entry with an apostrophe
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Proft" wrote:
I'm trying to enter records into a spreadsheet. everytime i Try to use a
dash, it converts into a date

All times are GMT +1. The time now is 02:06 PM.