View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] meh2030@gmail.com is offline
external usenet poster
 
Posts: 135
Default 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