Custom Formatting in Excel (SOLVED)

[phantom1975]

I want to change the formatting of a range of cells so that when I type ANY character in it, 3 letters will precede it. For instance, if I use the following in customer formatting, it gives me somewhat of the desired effect:

AZC#

This only works with numbers though. What do I replace the # with so that any character can be typed?

_________________
Pass on what you have learned. Support this great website by clicking on the sponsor's ads!.
This message was edited by phantom1975 on 2002-09-10 09:02
This message was edited by phantom1975 on 2002-09-10 21:54

 

[Jim North]

Try "AZC"@

 

[Mudface]

Try formatting as "AZC"@.

 

[Andrew Poulsom]

This number format worked for me:

"AZC"#;"AZC"#;"AZC"@

 

[phantom1975]

Thanks all. I knew it would be an easy one. Doing a search in the help file for "format" and "custom" didn't yield the answer I needed. Thanks again.

 

[phantom1975]

Thanks all. I knew it would be an easy one. Doing a search in the help file for "format" and "custom" didn't yield the answer I needed. Where might I find a list of all the space holders for formatting? Thanks again.

 

[Jim North]

I found in in the Excel help text

first I searched on FORMAT

then I selected CUSTOM from the keywords box

then I selected "CREATE A CUSTOM NUMBER FORMAT" from the topic window

Once there I saw a hyperlind at the bottom for "TEXT OR SPACING"