MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 97 turns dash into slash

Posted by Gene Kunkel on March 20, 2001 1:58 PM

When using Excel 97, you are entering a formula into a cell and if you use a dash it will turn into a slash when you start to enter the next number. For example, if you enter A5-B5-9 the dash before the 9 turns into a slash as soon as you enter the 9. You can go back and edit the formula and it is OK as long as you don't type a number after the dash. We've reloaded Office as well as removed the users profile from WinNT 4.0 but nothing seems to help. Any suggestions would be appreciated.

Posted by cpod on March 20, 2001 4:31 PM

Excel thinks you are trying to enter a date. Just format the cell as text before entering your data.

Posted by cpod on March 20, 2001 4:34 PM

If you are trying to enter a formula then put and equal sign first: