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.

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);_($* "-"??_);_(@_)



[email protected] 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

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);_($* "-"??_);_(@_)
>
>
>
> [email protected] 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