| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting - Applying Format Based Custom Functions | Excel Discussion (Misc queries) | |||
| Custom Format text | Excel Discussion (Misc queries) | |||
| Compare text in cell to custom text format?? | Excel Discussion (Misc queries) | |||
| Use custom format to add text to a text entry. | Excel Worksheet Functions | |||
| Custom formatting for text cells | Excel Discussion (Misc queries) | |||
Linear Mode
