how do i display numbers in lacs

[Guest]

i require to display numbers in a worksheet in lacs

 

[sanskar_d]

i require to display numbers in a worksheet in lacs

Hi ketan,

is it that you want the numbers to be converted in words or you want a
comma seperation.

regards,

sam

 

[mangesh_yadav]

Select the cells which you want to format.
Format > Cells > Custom, and enter the following in the box.
[>=10000000]#\,##\,##\,##0;##,##0

Manges

 

[Bob Phillips]

See http://tinyurl.com/8n4fz