Thread: vba excel
View Single Post
  #3   Report Post  
Ken Wright
 
Posts: n/a
Default

Format / Cells - Pick any numeric format, then hit custom and put a comma at
the end of each segment, eg if you just used number then you would have

0.00 so add comma to get
0.00,

or from 0 to 0,

Accounting as an example

_-£* #,##0.00_-;-£* #,##0.00_-;_-£* "-"??_-;_-@_- to
_-£* #,##0.00,_-;-£* #,##0.00,_-;_-£* "-"??_-;_-@_-

Each comma will reduce by factor of 1000, so 2 commas give you millions etc

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"vba wannabe" wrote in message
...
Greetings

I am really baffled by all those vba jargons

Want to learn more. Can someone suggest a
site providing simple step by step instruction
to learn excel vba

Thanks