Use a custom format of

#,##0,;-#,##0,

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Simon Wong" wrote in message
...
Hi all

Wish to format a cell to display numeric figures with thousand omitted.
i.e, say HK$1,789,123.00 to display as HK$1,789
How can I do that? (rather than dividing the cell by 1,000 then limit
decimal places to 0)

Thanks very much
Simon