Custom Formats

  • Thread starter Thread starter Sabrina
  • Start date Start date
S

Sabrina

I'm formatting cells with the following format
0##"-"##"-"#"-"##"-"##"-"###"."##

I need to be able to add an additional letter(not number)
to the end and I can't figure out how to retain my format
once the text is added.
 
Try this:
0##"-"##"-"#"-"##"-"##"-"###"."## "A"
If you simply want the dashes between the numbers, you may omit the quotes
around them.
 
Sabrina said:
I'm formatting cells with the following format
0##"-"##"-"#"-"##"-"##"-"###"."##

I need to be able to add an additional letter(not number)
to the end and I can't figure out how to retain my format
once the text is added.
Click to expand...

If you mean that you want to be able to type in a letter of your choice at
the end of the number, this cannot be done. Only numbers can be
custom-formatted, and anything containing a letter is text, not a number.
 
Back
Top