Show number in thousands

[Terence]

I have a number in a cell for 5,562,242. Without
inserting a column and dividing that number by 1,000, is
there a way to format that number to only show up as 5,562?

 

[Norman Harker]

Hi Terence

Format > Custom format #,###,

If you want to cover negatives the same way use:

Format > Custom format
#,###,;-#,###,

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Frank Kabel]

Hi
try the custom format
#,#,