custom inputs


T

Tom

I am using Office xp and I need to enter some part numbers that are formatted
in the following manner: 123-abc-456
three numbers then 3 letters then 3 numbers separated by dashes. I tried to
create a custom number format using 000-000-000 or 999-999-999 . It won't
work with the apha characters. as long as it is all numbers it works fine.
Can such a custom input format be constructed? Your help is most appreciated

email (e-mail address removed)

Thanks

Tom
 
Ad

Advertisements

J

Jim Thomlinson

There is no custom formatting for text... You can either use a macro that
responds to the on change event or you can place the formatted text in a
seperate cell with a formula...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top