How do I format cells as custom and keep text formatting?

[sherrik]

Trying to format a cell and text, need to keep zeros in front but also need
to custom format to be a upc code. Need only 12 characters and need dash in
the middle. I have tried everything please help!

 

[Peo Sjoblom]

Custom formats are only for number formats, not text.
If your data always have the same number of digits you can use a custom
format
and display a leading zero if it is less than 16 digits.

--


Regards,


Peo Sjoblom

 

[Rabbiosi]

When you use the custom format, just use zeros in place of the actual digits
in the formula bar. You can still add the dash in the middle, just count out
the numbers to get the length needed.