how do i display numbers in lacs
 

i require to display numbers in a worksheet in lacs

ketan Wrote:
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
:confused:


--
sanskar_d
------------------------------------------------------------------------
sanskar_d's Profile: http://www.excelforum.com/member.php...o&userid=24217
View this thread: http://www.excelforum.com/showthread...hreadid=379280

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

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=379280

See http://tinyurl.com/8n4fz

--
HTH

Bob Phillips

"ketan" wrote in message
...
i require to display numbers in a worksheet in lacs