i need
00901002409
as
009-01-002-409
with the preceding 0's
when i try
<colgroup><col style="mso-width-source:userset;mso-width-alt:3986;width:82pt" width="109"> <col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>does not show me answer just the formula i put in
thanks so much
00901002409
as
009-01-002-409
with the preceding 0's
when i try
00901001120 | =TEXT(G4,"???-??-???-???") |
00901001122 | =TEXT(G5,000-00-000-000) |
<colgroup><col style="mso-width-source:userset;mso-width-alt:3986;width:82pt" width="109"> <col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>
thanks so much