FormatNumber

Expand Post »

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 ?

Similar Threads

How to make a highscore in VB 2005 in VB.NET
Log is here. But Code ?? How to get this? in ASP.NET
Help on DataList and Repeater Problem in ASP.NET
Format GridView Columns in ASP.NET
Literal vs Repeater/Datalist for 2 values in ASP.NET

Jouni79

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Jun 2009

Permalink

Jun 3rd, 2009

Re: FormatNumber

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

QVeen72

Reputation Points: 84

Solved Threads: 140

Posting Shark

Offline

923 posts
since Nov 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: How to format number?

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Bikram Singh

DaniWeb Message

Cancel Changes

User Name
Password