Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 453
  • 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
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

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