Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Click here to start participating now! Also, check out the New User Guide.
Adding more #'s to Excel cells
Name: Tboy Date: August 9, 2006 at 17:38:53 Pacific OS: xp home CPU/Ram: 512
Comment:
I have a spreedsheet with a colunm of phone numbers, I need to add the area code 604 to all of them...... is there a way to do this other than one at a time?
Name: Michael J (by mjdamato) Date: August 10, 2006 at 16:25:14 Pacific
Reply:
One word of caution. Once you complete the above action you cannot remove the original column with the phone numbers or else you will lose the "new" numbers in the concatenated colum.
You can "break" the link between the cells so you don't have to keep the original by doing the following. 1) Select the colum with the new concatenated value, fromt he menu select Edit<Copy, 3) From the menu select Edit<Paste Special, 4) In the dialog box that comes up select the option "Value" in the top half and select OK.
The values int he new column will now include the area code but will no contain the formula from before and you can delete teh original phone number column.
Summary: I am trying to assign a user defined VB function to excel cell. I wrote a s simple function called testy() in VB editor that returned a number. Function testy() As Single testy = 2.4 End Function ...
Summary: Sorry about the posting - I'm new to this - hope this is more readable Hello 650Pete Times in Excel appear difficult, but if you ensure that all data entry follows a time format that Excel recognizes,...
Summary: 1 - Write or record a macro that performs the Refresh All function. 2 - Store the macro in the ThisWorkbook module of the workbook. 3 - Place a "button" (a shape, a textbox, etc.) on the Main page. 4 ...
0 
Outlook web Link
