Formatting decimal to show in a cell comment with VBA

  • Thread starter Thread starter Bobby
  • Start date Start date
B

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!
 
Range("F11").Comment.Text Text:=" " & format(Range("F12"),"0.00")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stacking data in a comment 3
format 9
Get number in cell add to it and put back in same cell 1
VBA to move from one cell to another cell 6
Automatically chnage number format of a range of cells 2
Excel VBA 1
VBA insert comment only when cell in a range changes first time 5
pivot table loosing decimals (vba) 1

Back
Top