There is a one-column table. A user would type a four-digit number into a cell. The cell would automatically convert it to a stored format with that number.
For example: Cell A2 is blank
I type 45 and press enter.
Excel automatically converts the cell to read RM17-0045.
If another user types 102 into cell A3
Excel automatically converts the cell to read RM17-0102.
This would be for all entries in column A.
Could anyone show me how to do this? I want to learn.
Thanks!
you can do with index match formula. If you attach sample file i will do that.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
I hope that this is what you need.
You cannot eat a cake and heve a cake in the same time and the same cake (with formula) but you can try look for VBA on this forum: Excel Programming / VBA / Macros
Custom formatting will give you RM17-0045 but also RM17-00102 not RM17-0102. If RM17-0102 for 102, 45 will be RM17-045
Last edited by sandy666; 06-18-2017 at 06:01 PM.
Not sure I understand, but I Custom formatted cell A2 as "RM17-"0000
Then typed 47 into cell A3. (Other numbers following in column A.)
The formatting automatically followed.
Dave
I had to eat my words. I created advanced dashboard with formulas and thinking just about itDave hit the nail on the head !
It happens. Been there, done that.
You can go to "office button" > "Excel option"
>Click on "Proofing"
>Click on "Auto Correct option"
>In Auto Correct Tab > in replace field type "45" & in with field type "RM17-0045" > Click on "Add" > Click "ok" > Click "ok"
Same process for other numbers.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks