Custom Formatting in Excel (SOLVED)

phantom1975

MrExcel MVP
Joined
Jun 3, 2002
Messages
3,962
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
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

phantom1975

MrExcel MVP
Joined
Jun 3, 2002
Messages
3,962

ADVERTISEMENT

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

MrExcel MVP
Joined
Jun 3, 2002
Messages
3,962
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

MrExcel MVP
Joined
Jun 20, 2002
Messages
791
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"
 

Forum statistics

Threads
1,144,221
Messages
5,723,102
Members
422,477
Latest member
pete101

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top