Tech Support Guy banner
  • Please post in our Community Feedback thread for help with the new forum software! If you are having trouble logging in, please Contact Us for assistance.
Status
Not open for further replies.
1 - 6 of 6 Posts

·
Registered
Joined
·
81 Posts
Discussion Starter · #1 ·
I have a very large workbook that has numbers in millions and thousands. I would like to be able to convert all numbers to thousands. In other words, the number 1,373,963 becomes 1,374 or the number 61,250 becomes 61.

Short of dividing hundreds of numbers by 1000, is there a way I can format to have this occur?
 

·
Registered
Joined
·
2,311 Posts
Re: custom format: #,###,

Hey, cool, that works for thousands,
AND #,###,,
works for millions.

Never knew .... Thanks, Glas.
 

·
Registered
Joined
·
395 Posts
But the actual values used in formulas are not being rounded. So 2 + 2 might not equal 4.

Looks good during a presentation...

=ROUND(value or cell, -3)/1000 + Integer number format is the correct solution.

Since I cannot understand how someone could deem proper to build a wks where 2+2 could also equal 3 or 5, I'm not going to argue. The last post will remain hers.
 
1 - 6 of 6 Posts
Status
Not open for further replies.
Top