Decimal-to-string formatting

[IlyaRabyy]

Colleagues,

Say, I have some numeric value of type Decimal (it's actually a dollar amount), and I need to insert it to a string.
lnChkValue.ToString() works (but of course!), however:

if it's, say, 123.45 - it gives "123.45"

but

if it's 123.40 - it gives "123.4" (zero's lost)

I tried to find the answer on how to format the output of the Decimal.ToString() on the MS documentation... and either I'm a total dullard, or there's nothing to answer my question there indeed.

(There's a TRANSFORM() function in VFP, which would allow me something like TRANSFORM(lnChkValue, "@ ###.##") and the output would be "123.40"... just FYI.)

TIA!

Regards,

Ilya

 

[strongm]

Format(lnChkValue, "###.##")

 

[IlyaRabyy]

Works!



Actually, it s./b. Format(lnChkValue, "###.00"), but it's a small detail.
Thank you, colleague!

Regards,

Ilya

 

[strongm]

Ah, you asked for 'something like TRANSFORM(lnChkValue, "@ ###.##")', so that's what I gave you