ExcelBanter - how do i stop excel from changing a dash to a zero in a cell?

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do i stop excel from changing a dash to a zero in a cell? (https://www.excelbanter.com/excel-worksheet-functions/52829-how-do-i-stop-excel-changing-dash-zero-cell.html)

green51

how do i stop excel from changing a dash to a zero in a cell?

when I put a dash (0005 - 001) excel changes the dash to a zero and it is
driving me freakin crazy. It just started doing this.

Peo Sjoblom

how do i stop excel from changing a dash to a zero in a cell?

Look if you have a dash replaced with a zero under toolsautocorrect options
somebody might have joked with you

--
Regards,

Peo Sjoblom

(No private emails please)

"green51" wrote in message
...
when I put a dash (0005 - 001) excel changes the dash to a zero and it is
driving me freakin crazy. It just started doing this.

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