| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DP Auto increment
Hi,
Is it possible for a function in a cell or a macro driven line to look at a cell and change the target cell from this reference cell to 1 decimal place more than the reference? IE Range("C13").NumberFormat = _ Range("d13").NumberFormat The D13 cell might have 0.00 DP formatting, but I need C13 to be 0.000 based on D13's DP formatting. The above just makes C13 the same as D13, IE 0.00 DP. Cheers for any help, Aaron. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
DP Auto increment
If it's as simple as what you describe:
Range("C13").NumberFormat = Range("d13").NumberFormat & "0" It would get tougher if your formatting were more like: _($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_) wrote: Hi, Is it possible for a function in a cell or a macro driven line to look at a cell and change the target cell from this reference cell to 1 decimal place more than the reference? IE Range("C13").NumberFormat = _ Range("d13").NumberFormat The D13 cell might have 0.00 DP formatting, but I need C13 to be 0.000 based on D13's DP formatting. The above just makes C13 the same as D13, IE 0.00 DP. Cheers for any help, Aaron. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
DP Auto increment
Thanks for that, it was exactly what I was after. I tried + 0.0 etc but
it only overrode the range("d13") part so this is now solved with & 0. Thanks again, Aaron. Dave Peterson wrote: If it's as simple as what you describe: Range("C13").NumberFormat = Range("d13").NumberFormat & "0" It would get tougher if your formatting were more like: _($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_) wrote: Hi, Is it possible for a function in a cell or a macro driven line to look at a cell and change the target cell from this reference cell to 1 decimal place more than the reference? IE Range("C13").NumberFormat = _ Range("d13").NumberFormat The D13 cell might have 0.00 DP formatting, but I need C13 to be 0.000 based on D13's DP formatting. The above just makes C13 the same as D13, IE 0.00 DP. Cheers for any help, Aaron. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to make excel auto enter increment invoice numbers. | Excel Discussion (Misc queries) | |||
| Auto increment chart range montly | Charts and Charting in Excel | |||
| how to auto increment a number each time i open the worksheet | Excel Worksheet Functions | |||
| Auto increment over multiple worksheets | Excel Worksheet Functions | |||
| How do I auto increment cell value on print in Excel | Excel Worksheet Functions | |||
Linear Mode
