inserting the numbers into excel column ?
 

Hi all,

I need to get my excel table column A filled with the numbers in this format
:

____A ______ B ______ C
(1),
(2),
(3),
....
....
(1749),
(1750),

Could someone help me with a simple macro which could do that for me ?

Thanks a lot in advance !

inserting the numbers into excel column ?
 

On Jan 17, 3:41*pm, "wind****er" wrote:
Hi all,

I need to get my excel table column A filled with the numbers in this format
:

____A ______ B ______ C
* * * *(1),
* * * *(2),
* * * *(3),
...
...
* * *(1749),
* * *(1750),

Could someone help me with a simple macro which could do that for me ?

Thanks a lot in advance !

You don't need a macro for this. Simply create a custom format.

Format | Format Cells / Category: Custom / Type: (#)

Matt

inserting the numbers into excel column ?
 

On Jan 17, 3:41 pm, "wind****er" wrote:
Hi all,

I need to get my excel table column A filled with the numbers in this format
:

____A ______ B ______ C
(1),
(2),
(3),
...
...
(1749),
(1750),

Could someone help me with a simple macro which could do that for me ?

Thanks a lot in advance !

Sub Macro1()
Dim k As Integer
Dim str As String

Columns("A:A").NumberFormat = "@"

Cells(1, 1) = "_____A"
Cells(1, 2) = "_____B"
Cells(1, 3) = "_____C"


For k = 1 To 1750
str = "(" & k & ")"
Cells(k + 1, 1) = str
Next

End Sub