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

[gosa]

Hi,


I'm using the following code.

Please Login or Register  to view this content.

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

[romperstomper]

Change the cell format instead:

Please Login or Register  to view this content.

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

[gosa]

Change the cell format instead:

Please Login or Register  to view this content.

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

Hi,

Thanks. The numberformat is showing up correctly.

Also thanks for the headsup. I don't want the use the Bankers Rounding.
Luckaly you've got eagle eye's.
Should I be using the following instead?

Please Login or Register  to view this content.

Thanks.

[romperstomper]

Yes - that will give you 'normal' rounding.

[gosa]

Great!
I really wouldn't have known if you didn't mention it.
Thanks again!