I'm using a code provided to me but there is something I would like to fix.
it populate the symbol (-) automatically. but if for example I type the number together 333333333 it only type 333-333-33
Could you please help me fix the code in order to enter the number one of the other and it populate the symbol (-) automatically
Attached is the excel documentHTML Code:
I can't duplicate that error in your file or a separate one. If I keep typing "3" I get "333-333-3333"
what i mean is that the 4th time you press the number 3 it becomes the symbol (-). Is there a way that the symbol appears automatically after the 3rd and the 6th numbers are typed?
Set your formats on the home ribbon, number, special, phone number.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi Alan,
how do I add that format to the above code?
Thank you
My first question is why not do it in native excel? Secondly, try using the macro recorder and then tweaking it.
This Macro works perfect
Please Login or Register to view this content.
Didn't the solution(s) offered here deal with the issue?
http://www.excelforum.com/excel-prog...bers-only.html
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks