Formating a number in a cell
On May 15, 5:11 pm, Farhad wrote:
Hi,
Try this:
=SUBSTITUTE(A1,"-","")
assumed that your string is in the cell A1.
Thanks,
--
Farhad Hodjat
" wrote:
I have the following data in a cell 00000-0000-00 and I want to format
the cell to remove the dashes, 00000000000. How would I do that?
Thanks so much!- Hide quoted text -
- Show quoted text -
Thank You! Your solution worked perfectly!
|