Formatting Numbers with zeros and hypens

[csiArun]

Hey Guys,

I am trying to figure out this formatting issue in excel. I tried multiple formula (Replace,(Left,Mid,right),Text("000").

I am trying to format this number value from "252 1 02 27"(this is exactly how it is appeared on the excel sheet)
into "252-01-02-27"


Thank you

[shg]

=substitute(a1, " ", "-")

[csiArun]

=substitute(a1, " ", "-")

Hey shg,

It worked the substitute. Is there a way to format the single digit to be displayed as 01 instead 1

[shg]

No obvious way -- it depends on the variety of number forms that would have to be accommodated.