Dear Dhananjay,
Please go thru the links below, this will give you some idea about the
custom formats.
http://www.ozgrid.com/Excel/CustomFormats.htm
http://www.ozgrid.com/Excel/excel-custom-number-formats.htm
Regards
Andy
On Sun, Aug 9, 2009 at 10:25 PM, Dhananjay Pinjan wrote:
> Hat's off Mas
Hat's off Master.
It's working very fine. Thanks for your valuable support.
One more question about the custom format, How to improve custom formatting.
Thanks again with waiting for your reply with detailed help about "CUSTOM
FORMATTING" (a very useful option/function in Excel).
Regards,
Dhanan
Dear Dhananjay
Please find attached the solution.
1) For the rounding of the numbers, I have used : =ROUND(B2,-1) in the
Column C.
2) For the formatting of the numbers I have used the following custom format
:
[>=1000]##\,##\,##\,###.00;[>=10]##\,##\,###.00;#,##0.00
Please let me know if
