schimmel1977
New Member
- Joined
- Sep 6, 2005
- Messages
- 22
I have a column with a bunch of 9 digit numbers (e.g. 05-456-3432) I need to remove the dashes but when I do excel automatically removes the zero in the front of my nine digit number. Is there a way to add a ' to the begining of each cell without actually having to type a ' over and over. Thanks for any help.