| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing a column's number of decimal places
I want to change a specific column's number of decimal
places to 1. How can I do this simply from within code? Do I have to select the column first, then apply the code or can I change the column without selecting it first? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing a column's number of decimal places
Hi
one way: columns(1).numberformat="0.0" -- Regards Frank Kabel Frankfurt, Germany Shaun Allan wrote: I want to change a specific column's number of decimal places to 1. How can I do this simply from within code? Do I have to select the column first, then apply the code or can I change the column without selecting it first? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing a column's number of decimal places
As simple as that! Amazing! Thank you!!
-----Original Message----- Hi one way: columns(1).numberformat="0.0" -- Regards Frank Kabel Frankfurt, Germany Shaun Allan wrote: I want to change a specific column's number of decimal places to 1. How can I do this simply from within code? Do I have to select the column first, then apply the code or can I change the column without selecting it first? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Decimal Places for Multiplication | Excel Discussion (Misc queries) | |||
| changing decimal places according to formula result | Excel Discussion (Misc queries) | |||
| Chart Number Decimal Places | Excel Discussion (Misc queries) | |||
| Converting a number to 2 decimal places | Excel Discussion (Misc queries) | |||
| Changing default decimal places | Excel Discussion (Misc queries) | |||
Linear Mode
