Maybe using autocorrect would be sufficient.

Tools|Autocorrect options|Autocorrect tab
replace: 29H73
with: MCY ID 29H73
(and the other stuff, too)

This is specific to each user, though. And the autocorrect list is also shared
by the other programs in the office suite (MSWord, PPT, ...)

An alternative maybe to just do the normal data entry, then when you're done,
just do a few Edit|Replaces.



Access Joe wrote:

Hi all,

I want to create a custom cell format that allows for the following:
When someone types five digits (could be alphabetic or numeric or both),
automatically add "MCY ID" before it.

So for example:
if you type: 29H73, it'll automatically change to "MCY ID 29H73"
if you type: 9992A, it'll automatically change to "MCY ID 9992A"
if you type AA76P, it'll automatically change to "MCY ID AA76P"

ETC.

Is this possible? I'm familiar with Custom cell formatting, but can't
figure out how to do that specifically. It's the letters that are messing me
up.

Thanks!
Joe

--

Dave Peterson