Display Values in thousands

S

Shamsuddeen

Active Member
Joined
Feb 16, 2002
Messages
292
Hi all!

I would like to have a custom format to display the values in thousands in the selected cells.

Eg. 125,450,860 should display as 125,451


Thanks in advance

Shamsuddeen
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Sort by date Sort by votes
Shamsuddeen said:
Hi all!

I would like to have a custom format to display the values in thousands in the selected cells.

Eg. 125,450,860 should display as 125,451


Thanks in advance

Shamsuddeen
Click to expand...

Working great!!
Thanks
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Solved
Display result of formula which is millions as nn.n without losing original value of cell and no 'M' in the result cell either.
Replies
3
Views
348
awoohaw
awoohaw
Keebler
  • Solved
Change cell color without "Conditional Formatting"
2 3
Replies
26
Views
670
Keebler
Keebler
G
  • Question
drag down serial number/ incremental wise upto thousands of cells
2
Replies
15
Views
218
Scott Huish
Scott Huish
R
  • Solved
Custom Chart template when using slicer
Replies
2
Views
124
RodneyW
R
R
  • Question
Display image based on value in a cell
Replies
3
Views
245
RodneyW
R

Forum statistics

Threads
1,214,812
Messages
6,121,699
Members
449,048
Latest member
81jamesacct

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top