[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 447
  • Last Modified:

Need help to format the number

I have pretty big numbers.

ReadDate      GrandUsage (in KWH)
5/1/2013      140620557.259401  
5/2/2013      148021735.4115

how to convert to fixed format?
0
rfedorov
Asked:
rfedorov
2 Solutions
 
peter57rCommented:
You'll have to give us an example of what you want the results to look like.
0
 
rfedorovAuthor Commented:
140620557.259401  
That is the problem. Since it looks like a really big number , I even do not know how it shoul d be:  may be like this???

140620557.259401  should be

140,620,557.26
0
 
Rey Obrero (Capricorn1)Commented:
in the query design grid, right click on the column for GrandUsage

in the Field Property Sheet, select Fixed in the Format property


you can also set the field property in the design view of the table
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
Gustav BrockCIOCommented:
Use this format:

strBigNumber = Format(140620557.259401, "#,##0.00")

or use in the format property of the textbox:

  #,##0.00

/gustav
0
 
rfedorovAuthor Commented:
To cactus_data:
thank you very much, what i need!

To capricorn1:
I did it before and something happening to my precision and all my decimals just disappers...
0
 
Gustav BrockCIOCommented:
You are welcome!

/gustav
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now