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
|