MrDB4Excel
Active Member
- Joined
- Jan 29, 2004
- Messages
- 348
- Office Version
- 2013
- Platform
- Windows
I need to create a custom cell format as follows:
Example: 17a >
This custom format would only require me to enter for example 6c OR 23d OR 3f OR 17a OR whatever #a OR whatever #b OR whatever #c etc. etc. etc.
Do you get the picture?
Before the need for an alpha character this was simple. The custom format was either # ">" OR 0 ">".
Now with the additional alpha character being added such that in any given cell where this format exists I would type in a number and an alpha character and the result would simply add the > to the end of the number plus alpha character as in the below examples.
Any help is greatly appreciated.
10a >
10b >
10c >
13a >
13b >
13c >
13d >
16a >
17a >
18a >
Example: 17a >
This custom format would only require me to enter for example 6c OR 23d OR 3f OR 17a OR whatever #a OR whatever #b OR whatever #c etc. etc. etc.
Do you get the picture?
Before the need for an alpha character this was simple. The custom format was either # ">" OR 0 ">".
Now with the additional alpha character being added such that in any given cell where this format exists I would type in a number and an alpha character and the result would simply add the > to the end of the number plus alpha character as in the below examples.
Any help is greatly appreciated.
10a >
10b >
10c >
13a >
13b >
13c >
13d >
16a >
17a >
18a >