| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change cell type
Vacuum Sealed has brought this to us :
Derick Try Range("K2:K10").Select Selction.NumberFormat= "0.00" HTH Mick. Mick, Since NumberFormat is a read/write property of the Range object, there is no need to select it. (Unecessary selecting slows down code performance) Range("K2:K10").NumberFormat = "0.00" -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to change the background of a cell if I type a certain wor | Excel Worksheet Functions | |||
| How do you change the data type of a cell using VBA? | New Users to Excel | |||
| Change cell reference type | Excel Programming | |||
| Change Cell Value Across whole WorkSheet/ Workbook if cell type is currency | Excel Programming | |||
| How to change type of the cell? | Excel Programming | |||
![GS[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
