Question Locked

Removing dashes in excel

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a 12 digit code with a dash after the 4th and 8th digit. I need to remove the dash but when I select edit remove it changes the number to an error. For example, the cell 1234-5678-9012 would now look like 1.23578E+11. The column width isn't the problem. This doesn't happen if the cell is only 11 digits long.

5 replies

by chris910

This is not an error the cell is displaying the number in Scientific Notation. General Text--when you remove the dashes Excel recognises this as being a number and not text so it converts it to the Default number format for large numbers. What you need to do is to change the cell formatting from General to either Text, Number or Custom depending on the actual usage and sorting features you might be wanting to use.

by mmiller

Changing the format will work with some of the cells but not all. For example if there is a 16 digit cell that ends in 8 I will change the format to number and take away the decimals and Excel is dropping the 8 and adding a 0 in its place. This isn't everytime. It happens on more then one computer in the office. Thanks for your help.

by chris910

Are you sure that it is not just rounding off the last digit?

This discussion is closed to new replies.