Format Number

[vishalmarya]

i want to change the format of the number in a textbox

to have a thousand separator.

i.e. the number 12345.78 should change to 12,345.78 .

Problem is , by using format(num,"#,###")

12345.78 becomes 12346 . I want to have the decimal part as it is.


Thanks

[ober0330]

did you try:

Format(num, "#,###.##")

?

[MartinLiss]

Or...

Text1.Text = FormatNumber(Text1.Text, 2)

[kvreddy]

use this format
format$(text1,"###,###,##0.00")

[MartinLiss]

Originally posted by kvreddy
use this format
format$(text1,"###,###,##0.00")

That's exactly what FormatNumber does (and you don't have to worry about truncation).

[vishalmarya]

using Format(num, "#,###.##") gives a decimal point .


i.e. , if the number is 10000 result is 10,000. ( see decimal at the end) .

i have solved the problem by checking if the number contains decimal . if it does I use : "#,###" , and if doesn't i use the above one.

No General format string i guess ?