Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automation to add 99 before any 10 digits?
Hi all, Greeting for the day. I have serial number in a column like 0123456789 that is 10 digits however it has to 990123456789 The actual requirement is when i copy paste any 10 digits in a cell say A1 it should add 99 before 10 digits automatically to make it 12 digits. And if it is 9 digit it should add 990 before the 9 digits if it is 8 digit it should add 9900. Any help would be much appreciated. Thanks in Advance Raja -- Raja ------------------------------------------------------------------------ Raja's Profile: http://www.thecodecage.com/forumz/member.php?userid=497 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115081 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you change single digits to recognized double digits? | Excel Worksheet Functions | |||
VBA write macro change column with 3 number digits to 4 digits the | Excel Discussion (Misc queries) | |||
number 12 digits to 15 digits | Excel Discussion (Misc queries) | |||
How to customize number to 10 digits including 2 digits after deci | Excel Worksheet Functions | |||
Supressing the ctrl-c and other keys during word automation in automation | Excel Programming |