LinkBack URL
About LinkBacks
I have financial values of nn.nnnnnnnn that need to be in a format of $nn,nnn.nn
Example 51.6724651 needs to display as $51,672.465 - can anyone advise what best format to use?
I have financial values of nn.nnnnnnnn that need to be in a format of $nn,nnn.nn
Example 51.6724651 needs to display as $51,672.465 - can anyone advise what best format to use?
Hi,
You could do it like this
Formula:
Please Login or Register to view this content.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Hi Kausch,
If you would like to convert on the original cells, you may type "1000" in a blank cell, copy it, select the data source cell(s), right click, select paste special > Multiply > OK:
Capture.PNG
Then press Ctrl +1, change the cell format to Currency and set the decimal places to 3:
Capture.PNG
Capture.PNG
Last edited by Sylv!a; 04-26-2017 at 02:08 AM.
Seconded.Originally Posted by sweep
Im puzzled, you want to convert a "tens" number 51.6724651 to a "ten-thousand" number?
What range of base values are you dealing with, will they all be *1000?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks everyone - you've come through for me again! I was tinkering with the "cell formatting" options and didn't think it was as simple as that.
I call it "tunnel-vision" syndrome and not being able to laterally think outside the box. Your solutions worked a treat.
FDibbins - in answer to your question, the decimal point was in the incorrect place and treated as a "decimal" whereas I needed it to be a comma to indicate thousand's and the decimal three digits after the comma to indicate hundred's. The solutions given are perfect.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks