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
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