How to display figures with thousand omitted

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Use a custom format of

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

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Click FORMAT in the menu, and select CELLS. In the FORMAT CELLS dialog box,
locate CUSTOM in the CATEGORY list (it's at the bottom) and in the TYPE field
to the right of the list box enter the following custom format:

"HK$" ####.00
 
Back
Top