Format Problem

[biswassurajit]

Hi!
I need a number to be Formated as user defines.But Vb's Format command does not do anything.

I need the number to format like this:

#,##,##0.00

But Vb's format function returs me in the format

###,##0.00

Can I get the above format by Vb's format function if yes how?

Thanks

[phinds]

the VB help implies (obviously incorrectly) that you can do what you are trying to do, but you can't, so you'll have to roll your own. Check on planetsourcecode; maybe someone has already done it.

[TheCPUWizard]

I do not see where the VB information would imply any such thing, the comma character is explicitly stated as the THOUSANDS seperator.

The ',' character serves two purposes. First, if the format string contains a ',' character between two digit placeholders (0 or #) and to the left of the decimal point if one is present, then the output will have thousand separators inserted between each group of three digits to the left of the decimal separator. The actual character used as the decimal separator in the output string is determined by the NumberGroupSeparator property of the current NumberFormatInfo object that controls formatting.

[phinds]

I do not see where the VB information would imply any such thing

you are obviously correct. I didn't read the verbiage and misinterpreted the code. Thank you for point it out. The only thing I hate more than being wrong is being wrong and not knowing it.