Format Function in VB 2005

[briprogram]

I am sending a string value to a function and using the value in this Format Function within the called function

DollarAmount = Format(DollarAmount, "000000.00")

During debug I notice it changes DollarAmount variable for instance from "120.00" to "000000.00" instead of "000120.00" like it should. I am wondering why it is not working?

Thanks in Advance
Brian

 

[misterstick]

you could try changing dollaramount from a string to a single:

DollarAmount = Format(CSng(DollarAmount), "000000.00")

mr s. <

 

[mmilan]

DollarAmount = String.Format("000000.00",DollarAmount)

or, if that doesn't work, how about

DollarAmount = String.Format("000000.00",Decimal.Parse(DollarAmount))


Not tested either...

 

[chrissie1]

The format function will only work correctly with numeric values if you want to format that so misterstick and mmilans second attempt should both work.

Christiaan Baes
Belgium

My Blog

 

[briprogram]

Thanks to all,

I tried misterstick's first and it worked. I haven't tried the others yet and don't know if I will have time to.

In this case CSng converted the string to a Single variable from the string I was trying to convert.

I was using VB.NET in a nutshell

Format Function
Class
Microsoft.VisualBasic.Strings

Syntax
Format(expression[, style[, dayofweek[, weekofyear]]])

expression
Use: required
Data Type: String/Numeric
Any Valid string or numeric expression

Style
Use: Optional
Data Type: String
A valid Name or user-defined format expression

I figured having the String in the expression that it would worked.

Thanks to all for your help

 

[ZmrAbdulla]

may be this one..

DollarAmount = Format([COLOR=red]Val[/color](DollarAmount), "000000.00")

________________________________________________________
Zameer Abdulla
Help to find Missing people