Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting to 2 decimal places, placing a page break and autofitting a collumn/row height
Hi:
I need to do the following: 1. Format to a specific number of decimal places, where is this in the active cell/selection? 2. Create a page break after the current cell/row. 3. Autofit a collumn/row to the data contained within. Any help appreciated. Sean. __________ Information from ESET NOD32 Antivirus, version of virus signature database 4035 (20090425) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting to 2 decimal places, placing a page break and autofitti
Hi,
I think you mean that if there is a (say) 3 in the activecell you want that cell formatted to 3 decimal places, is that correct? If so try this With ActiveCell .NumberFormat = "0." & WorksheetFunction.Rept("0", ActiveCell.Value) .EntireColumn.AutoFit End With ActiveWindow.SelectedSheets.HPageBreaks.Add befo=ActiveCell.Offset(1) Mike "Sean Farrow" wrote: Hi: I need to do the following: 1. Format to a specific number of decimal places, where is this in the active cell/selection? 2. Create a page break after the current cell/row. 3. Autofit a collumn/row to the data contained within. Any help appreciated. Sean. __________ Information from ESET NOD32 Antivirus, version of virus signature database 4035 (20090425) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting to 2 decimal places, placing a page break and autofitti
Hi:
regarding the decimal places, I just want to format to 2 decimals, not the number in the cell. Any help appreciated. Sean. "Mike H" wrote in message ... Hi, I think you mean that if there is a (say) 3 in the activecell you want that cell formatted to 3 decimal places, is that correct? If so try this With ActiveCell .NumberFormat = "0." & WorksheetFunction.Rept("0", ActiveCell.Value) .EntireColumn.AutoFit End With ActiveWindow.SelectedSheets.HPageBreaks.Add befo=ActiveCell.Offset(1) Mike "Sean Farrow" wrote: Hi: I need to do the following: 1. Format to a specific number of decimal places, where is this in the active cell/selection? 2. Create a page break after the current cell/row. 3. Autofit a collumn/row to the data contained within. Any help appreciated. Sean. __________ Information from ESET NOD32 Antivirus, version of virus signature database 4035 (20090425) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __________ Information from ESET NOD32 Antivirus, version of virus signature database 4035 (20090425) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __________ Information from ESET NOD32 Antivirus, version of virus signature database 4042 (20090429) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Decimal Places | Excel Programming | |||
Formatting Numbers with Decimal Places | Excel Programming | |||
conditonally formatting decimal places | Excel Discussion (Misc queries) | |||
formatting decimal places in code | Excel Programming | |||
Currency Formatting to 3 decimal Places | Excel Programming |