Hi,
The first one will not work
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Tom Hutchins" wrote in message
...
A couple of alternatives:
- format the cell as Text before removing the dashes
- put an apostrophe before the 0 before removing the dashes
- remove the dashes in another cell, using SUBSTITUTE:
=SUBSTITUTE(A1,"-","")
- give the cell a custom number format like 000000000
Hope this helps,
Hutch
"Pierre" wrote:
Good day all,
I am trying to change this number 01-465-9273 to show up as 014659273. It
is
easy enough to make the (-) go away but it takes the zeros at the
beginning
of the number away as well which defeats the purpose
Thanks
--
Pierre