Format and round decimals

[ignasis]

Hello again!

This time is about formatting number to percent and round it to 2 decimals.

I've tried the following:

Excel	VBA	Code
0,00136678989	1,36678989	.cells(10,6)
0,00136678989	0,0014	Round(.Cells(10,6), 4)
0,00136678989	1,36678989E-03	Format(.Cells(10,6), Percent)
0,00136678989	0,0014	Round(Format(.Cells(10,6), Percent), 4)

What I need is to see in VBA --> 1,36%

I've also tried changing Excel values to % format, but VBA seems not to take that %values either.

Any suggestion would be greatly appreaciated,

Thanks!

 

[Pecoflyer]

Perhaps using the FLOOR function? Application.WorksheetFunction.Floor(...)

(that's all I know, not being a VBA man) :redface:

 

[ignasis]

thanks for you reply Pecoflyer,

If I am not wrong, I think floor doesn't work with negative numbers.

And I think round(3.7) =4 and floor(3.7)=3 so I would be in the same situation

 

[ignasis]

well, I am really sorry but I found the SILLY issue... just need to put "Percent" instead of Percent.

So the correct answer is format(.cells(10,6), "Percent") and it returns 0,13% (not 1,36%, I typed wrong in the first post)

 

[snb]

Explore (VBEditor / helpfiles)

Sub M_snb()
   MsgBox FormatPercent(0.2375)
End Sub