Format Number

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

did you try:

VB Code:

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

?

Or...

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

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

Quote:

---

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).

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 ?