MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Format to 000's


Posted by Mike on August 15, 2001 2:48 PM

I have a worksheet that has several numbers and I want everything rounded to 000's. i.e $4,598,632 would read $4,599. I am trying to avoid having to put the round function in each individual cell becasue of the number of cells that need this. Any help would be appreciated.


Posted by lenze on August 15, 2001 2:57 PM

Custom Format
#,###,;;;

Posted by Mark W. on August 15, 2001 3:06 PM

Might what to exclude the semi-colons...

Posted by Mark W. on August 15, 2001 3:07 PM

Repost: Might want to exclude the semi-colons...