janjan_376
Board Regular
- Joined
- Oct 24, 2008
- Messages
- 75
Scenario:
I would like to make a box where I can enter integer. Then the last digit on the right will be cut and put into a designated cell:
example:
A1:A1000 contains store # from store 1 to 1000 respectively.
If 241 is entered on the box, the 1 will automatically go to cell B24. Then clear data on the box for another entry.
Please help. Thank you.
I would like to make a box where I can enter integer. Then the last digit on the right will be cut and put into a designated cell:
example:
A1:A1000 contains store # from store 1 to 1000 respectively.
If 241 is entered on the box, the 1 will automatically go to cell B24. Then clear data on the box for another entry.
Please help. Thank you.