Formatting a number to 1000s...

[steverbs]

Hi all.

Can anyone tell me how, using VB.NET, to format an SQL Server Money datatype to display the value in 1000s? So that 678900 would be 679 and 98 would be 0 etc.

Thank you.

Stephen.

 

[earthandfire]

You could try the Integer divide operator \ ie

678900\1000
98\1000
myvar\1000

Hope this helps

 

[steverbs]

I had actually tried that, but it kept giving me undesirable results (i.e. 900 / 1000 = 0.9, when I need 0). I think I may have found what I am after though. One of my colleagues just pointed out the '0,' format string that can be applied in the ToString method of a numeric Type.

I'll see how it does.

Stephen.

 

[earthandfire]

You are using / the divide operator, I suggested using \, the Integer divide operator


678900\1000 = 678 (exactly - no fractional part)
98\1000 = 0 (exactly - no fractional part)

Hope this helps.

 

[steverbs]

Oh, right. I'll give that a try then.

Thanks for your help.

Stephen.