Formatting decimal to show in a cell comment with VBA

[Bobby]

Can anyone help? This is my current code:

Range("F11").Comment.Text Text:=" " & Range("F12")

The F12 cell is define as a number with 2 decimal(i.e.: 4.60)

If the number that is assign is 4.60 as an example, the result looking
at the comment cell F11 is 4.6 the zero is always missing.

Thank's ahead!

[Niek Otten]

Range("F11").Comment.Text Text:=" " & format(Range("F12"),"0.00")

--
Kind regards,

Niek Otten


"Bobby" <[email protected]> wrote in message
news:[email protected]...
> Can anyone help? This is my current code:
>
> Range("F11").Comment.Text Text:=" " & Range("F12")
>
> The F12 cell is define as a number with 2 decimal(i.e.: 4.60)
>
> If the number that is assign is 4.60 as an example, the result looking
> at the comment cell F11 is 4.6 the zero is always missing.
>
> Thank's ahead!
>

[Bobby]

Thank's again Niek