Thread: get number instead of string when using Format(x, "#,##0.00")

Hi,


I'm using the following code.

Cells(1,1).Value = Format(Round(nTotal, 2), "#,##0.00")

When I look at the generated file I see that the cell is left aligned and there is an exclamation saying that the number has been saved as text.
This is obviously not what I want.

I checked the format function and it seems to return a string.
Is there a way to make sure it returns a number.


Thanks

Change the cell format instead:

With Cells(1,1)
   .Numberformat = "#,##0.00"
   .Value = Round(nTotal, 2)
End With

I assume you are aware that the VBA Round function does not work the same way as the worksheet version. (it uses Bankers Rounding)

Yes - that will give you 'normal' rounding.