How can I convert a string number to a number in Perl?

Excel - convert clipboard format to text in macro?

• Hi, I'm trying to do a simple thing in Excel with help of a macro. The task is to convert a number of the form 01014***** (* are placeholders for different numbers). In the end I want to get the following 100036:11014***** so I have to add the string "100036:1" and trim away the zero in the beginning. The idea is to simply be able to copy the input to clipboard in another program, then go to excel, click one button which is assigned a macro that converts the number to the output and copies it directly to clipboard, so that it can be used in another program. I did the following: macro: Sub convert() Range("C4").Select ActiveSheet.Paste Range("C5").Select Selection.Copy End Sub in C5 I have this formula: ="100036:1"&RIGHT(C4; LEN(C4)-1) Cells C4 and C5 are there to have the visual input/output, which I also need. I assigned the macro to a button. Now, this works really fine, but unfortunately as I click the button it doesn't paste the input as text, but as a number (even though I set the cell format to text - pasting overwrites this setting) i.e. my output is not correct. The question is whether there is a way to define what I'm pasting from clipboard as text? Or would you solve this whole problem differently? Sorry for the surely thumb question, but I'm a macro noob, so I can't really think of a solution... Thanks in advance for your help:)

• Answer:

  Try adapting this as a macro C4 your number C5 =SUBSTITUTE(C4,"0","100036:1",1)