Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Kjacob54
 
Posts: n/a
Default Formating Worksheet Cells

?
How do you format a worksheet to format all cells to round numbers to 2
decimal places. I am not talking about the cell format command that display
numbers. I am trying to have the speadsheet round all numbers. I know that
Round(Range("A1"), 2) will work on an indivdual cell. Can this be applied
to the enetire work sheet or range of cells?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting Filtered RC cell information into other worksheets Dennis Excel Discussion (Misc queries) 10 July 30th 05 01:54 AM
How do I link a cells formatting from one worksheet to another? ddepasquale Excel Worksheet Functions 0 July 26th 05 07:51 PM
Can I lock a set of cells in a worksheet? puneetarora_12 Excel Discussion (Misc queries) 3 July 8th 05 11:07 PM
Trace ALL dependent cells in any worksheet anywhere in Excel Graham Tapper Excel Worksheet Functions 6 March 11th 05 05:44 PM
Making cells compulsary to fill in on a worksheet abfabrob Excel Discussion (Misc queries) 7 February 4th 05 12:20 AM


All times are GMT +1. The time now is 09:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"