dashes needed excel 2016

[CrashOD]

i need
00901002409
as
009-01-002-409
with the preceding 0's
when i try

00901001122

<colgroup><col style="mso-width-source:userset;mso-width-alt:3986;width:82pt" width="109"> <col style="width:48pt" width="64"> </colgroup><tbody>
[TD="width: 109"]00901001120[/TD]
[TD="class: xl63, width: 64"]=TEXT(G4,"???-??-???-???")
[/TD]

[TD="class: xl63"]=TEXT(G5,000-00-000-000)[/TD]

</tbody>

does not show me answer just the formula i put in

thanks so much

 

[Momentman]

Did you enclose the 0000s in a double quote

like =TEXT(G2,"000-00-000-000")

 

[Fluff]

Make sure that the cell is not formatted as text & that "Show Formulas" on the formula tab is not checked.

 

[CrashOD]

Thanks so much!
by chance
00901002010
00901002011A
00901002012B
is there a way to have it fix it to
009-01-002-010
009-01-002-011-A
009-01-002-012-B

depending on what is there if a letter is there or not?