Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Data Entry Limitaion

0

Hi, I have a Excel form.

There a an cell that I want to set entry data as below conditions

1. Data Lenth is 8 charactors

2 Alway first 2 letters bigins with "RT" and others are must be numerics only

  Ex  -  RT120568,   RT550100, RT123456

Thanks

Neranjan

Answer
Discuss

Answers

0

I like to use Excel's Custom Format with a Prefix, like "RT" in your case.  Go to Home on Ribbon, then Format, then Format Cells.  Under Category select 'Custom' - then in TYPE box type RT000000 and enter.  You will need to copy this format down the column or cells you would like to have this format (use format painter or copy formats). Now you can just type a number and the RT prefix will be there.

Discuss

Discussion

Thanks Gentleman
It's work !!!
Thanks !
Neranjan (rep: 2) Mar 10, '20 at 11:52 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login