Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
a macro for inserting
Monkey Boy
if it is always 10 digits, you could try Sub ChangeFormat() Columns("A:A").NumberFormat = "000000-0000" End Sub "spreadsheet monkey" wrote: I need a solution/macro to insert a minussign (-) into a 10 digit number between digit 6 and 7 (to get a number looking like this xxxxxx-xxxx) I need to do it in a single column for all 65 536 lines of code in the spreadsheet. who of you is nerd enough to tackle this challenge? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro for inserting a row | Excel Programming | |||
Macro for copying & inserting a row | Excel Programming | |||
inserting row macro | Excel Discussion (Misc queries) | |||
Inserting A Row Macro | Excel Programming | |||
Inserting a Row With Macro - Help | Excel Programming |