| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting part of a column
I need to format a number to for decimal in all of column H and K and only
G13 to the end of the G column how do I do this? Mike |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting part of a column
Type this in the name box (to the left of the formula bar)
h:h,k:k,G13:G65536 hit enter format|cells|number tab choose the format you like. Mike wrote: I need to format a number to for decimal in all of column H and K and only G13 to the end of the G column how do I do this? Mike -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting part of a column
Mike,
I would think the difference is minimal. "Mike" wrote: Thanks for that that's just what I needed. Is it faster if I am formatting say 200 rows of data to format the whole column or to use the Rows.Count and only format the rows with data i them?? Thanks Mike "Toppers" wrote: Mike, Range("H:H,K:K,G13:G" & Rows.Count).NumberFormat = "0.000" Format with 3 decimal places HTH "Mike" wrote: I need to format a number to for decimal in all of column H and K and only G13 to the end of the G column how do I do this? Mike |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting part of a column
Thanks for that that's just what I needed.
Is it faster if I am formatting say 200 rows of data to format the whole column or to use the Rows.Count and only format the rows with data i them?? Thanks Mike "Toppers" wrote: Mike, Range("H:H,K:K,G13:G" & Rows.Count).NumberFormat = "0.000" Format with 3 decimal places HTH "Mike" wrote: I need to format a number to for decimal in all of column H and K and only G13 to the end of the G column how do I do this? Mike |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting part of a column
Mike,
Range("H:H,K:K,G13:G" & Rows.Count).NumberFormat = "0.000" Format with 3 decimal places HTH "Mike" wrote: I need to format a number to for decimal in all of column H and K and only G13 to the end of the G column how do I do this? Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting part of a number in a cell | Excel Worksheet Functions | |||
| Selecting part of a series for a chart? | Charts and Charting in Excel | |||
| Selecting part text in a textbox | Excel Programming | |||
| Help: selecting part of an array | Excel Programming | |||
| Selecting used part of a range | Excel Programming | |||
Linear Mode
