If I understand what you want correctly, select all the cells you want to
convert (you can select cells that have nothing in them as well if they will
or might get entries in the future also), right click the cell(s) and select
"Format Cells" from the popup menu that appears, then select Number from the
list on the left, change the number of "Decimal Places" field to 0 (I guess,
from the the example values you posted) and put a check mark in the "Use
1000 Separator (,)" check box, then click OK.

Rick Rothstein (MVP - Excel)


in excel a particular no e.g. 3600000 can be change by
using 1000 seprater i,e, 3,600,000, i am trying to convert
this no to 36,00,000. i have more than 2000 no to be convert.