Need Fast help pls... Format issue!

[Ali Eghtebas]

Hi,

Need fast help pls:

Format (1 "###,###.##") = "1" <<<<----- OK!

Format (0, "###,###.##") = "" <<<<----- WHY?

How can I make this work with Zero?

I need to use Format, otherwise it will be a time consuming work to process
0 in a If of some kind.
--
Thanks in advance
Ali Eghtebas Sweden

[Jochen Kalmbach]

Ali Eghtebas wrote:

Format (1 "###,###.##") = "1" <<<<----- OK!

Format (0, "###,###.##") = "" <<<<----- WHY?

How can I make this work with Zero?

Format (0, "###,##0.##") = "1"
--
Greetings
Jochen

Do you need a memory-leak finder ?
http://www.codeproject.com/tools/leakfinder.asp

[Armin Zingler]

"Ali Eghtebas" <al***@home.se> schrieb

Format (1 "###,###.##") = "1" <<<<----- OK!

Format (0, "###,###.##") = "" <<<<----- WHY?

How can I make this work with Zero?

Format (0, "###,##0.00")
--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

[Fergus Cooney]

Hi Ali, Jochen,

As Jochen demonstrated, you need a zero in every position where
you require a digit. The '#' in the format specification says 'put a digit
here if the value requires it but if not use a space'. The '0' specifies
either the number's digit or a zero.

So "###,###.##" means give me nothing if the number is zero.

Also, if you want your decimal places, you'd use "###.##0.00"

Regards,
Fergus

[rcb]

Format(0, "###,###.##,##0;;\0")

[Ali Eghtebas]

Thank you all for the quick replies. I really appreciate it!

--
Regards
Ali Eghtebas Sweden

[Herfried K. Wagner]

* Ali Eghtebas schrieb:

Need fast help pls:

Format (1 "###,###.##") = "1" <<<<----- OK!

Format (0, "###,###.##") = "" <<<<----- WHY?

How can I make this work with Zero?

Try this (untested): 'Format(0, "###,##0.##")'.

--
Herfried K. Wagner
Microsoft MVP
<http://www.mvps.org/dotnet>