Notifications
Clear all
General Excel Questions & Answers
4
Posts
3
Users
0
Reactions
266
Views
Topic starter
Hi Guru,Question again, what should i use if i want the specific cell to only accept 10 characters and should not accept any other characters beside numbers? i use the data validation but it can only set the limit of characters, not both at the same time.
Best regards,
Posted : 13/03/2017 4:23 am
I think you need to set your cel format correct to your wishes.
Just recently here on the MOTH website Mynda published a ton of information just for that.
You'll find it here: https://www.myonlinetraininghub.com/excel-custom-number-format-guide
Hope that helps?
Posted : 13/03/2017 4:23 pm
You will need a custom formula in the Data Validation.
Refer file attached.
Posted : 13/03/2017 7:06 pm
Topic starter
thank you both,
Posted : 14/03/2017 11:22 am
