Thanks for the answer. Unfortunately I am using Excel 2003. Thanks.

"trip_to_tokyo" wrote:

sorry, within the Number tab, select Number on the left hand side then:-

- click in the box called:-

Use 1000 Separator (,)

Apologies for error.

"trip_to_tokyo" wrote:

IN EXCEL 2007 take the following action:-

Highlight the cell(s) you wnat to change

- right hand click and select Format Cells (window of same name should
launch)

- Number tab

- click in the box called:-

Use 1000 Separator (,)

Hit OK

If my comments have helped please hit Yes.

Thanks.



"Jamal" wrote:

How do I format a number to show in thousands with comma seperator. For
example I would like to show 1050040 as 1,050. Thanks for your assistance.