DaniWeb Forum Index > Software Development > Visual Basic 4 / 5 / 6

Visual Basic 4 / 5 / 6 RSS

FormatNumber

•

Join Date: Jun 2009

Posts: 2

Reputation: Jouni79 is an unknown quantity at this point

Solved Threads: 0

Jouni79

Offline

Newbie Poster

FormatNumber

Jun 3rd, 2009

how about this sitsuation:

=FormatNumber(Sum(Fields!TotalProductPrice.Value),2)
it returns for exsample following: 1.2345. I need to replace . with ,
how can I do it ?

•

Join Date: Nov 2006

Posts: 848

Reputation: QVeen72 is on a distinguished road

Solved Threads: 120

QVeen72

Offline

Practically a Posting Shark

Re: FormatNumber

Jun 3rd, 2009

Hi,

Try This :
=Replace(FormatNumber(Sum(Fields!TotalProductPrice.Value),2),".",",")

Or Change the Local/Regional settings in Control Panel.
For Numbers, Give comma as DecimalSymbol.

Regards
Veena