![]() (i was probably trying too hard to make that happen before). On the finished cell and dragged or drug downward and it filled in the rest of them just fine. after doing just 1 cell, moving the mouse around to the lower right corner it turned into a plus sign, i clicked instead of me typing in the cell, a1, i clicked on the cell and it highlighted and did whats expected. ![]() A sample of your text will appear on the right portion. In the Category listbox, select your format. so the module as written, when trying to use formatmac(a1) it says syntax error, but formatmac(1122334455) produces 11:22:33:44:55 When the Format Cells window appears, select the Number tab. Ok, got it to work, i added it again as a module as this time it saw it. Note: In the formula, A2 is the first cell of the selected cell range. In the Data Validation dialog box, select Custom in the Allow drop-down list, copy the below formula into the Formula box, and then click the OK button. so it looks like Excel at least found it, but in the worksheet it will not let me use it. Select the cells you will only allow IP address format entering, then click Data > Data Validation. Avec? when powering on the computer today and opening up that file, it had a warning message that a macro is there from a source that cannotīe verified, enable macros anyway? yes. If i try to enter a function =FormatMAC(a1) then hit enter, it, the cell, says "Name?" as if it cannot find it at all. so i copied/pasted the function, and saved it, but in the spreadsheet ![]() But in Excel 2007 there is NOTHING in any of the menus there that indicates this, i had to find out from reading articles.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |