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