how do i display numbers in lacs

S

sanskar_d

ketan said:
i require to display numbers in a worksheet in lacs
Click to expand...

Hi ketan,

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

regards,

sam
:confused:
 
M

mangesh_yadav

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

Manges
 
Top