Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
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.
Re: Format to 000's
Posted by lenze on August 15, 2001 2:57 PM
Might what to exclude the semi-colons...
Posted by Mark W. on August 15, 2001 3:06 PM
Repost: Might want to exclude the semi-colons...
Posted by Mark W. on August 15, 2001 3:07 PM
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.