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

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!

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

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

"sherrik" wrote in message
...
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!

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

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.

"sherrik" wrote:

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!