Convert Millions number in Excel to Thousands

[shahid5788]

Hi,

Is there a formula that can help me convert my raw data which is in millions into thousands? I would like to have some sort of formula if possible rather than changing my cell formatting.



[TABLE="width: 399"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Original Data[/TD]
[TD][/TD]
[TD]What Formatt I need[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] 171,502.27[/TD]
[TD][/TD]
[TD] 172.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] 8,462,316.95[/TD]
[TD][/TD]
[TD] 8,462.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] 6,225,692.58[/TD]
[TD][/TD]
[TD] 6,226.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] (273,633.00)[/TD]
[TD][/TD]
[TD] (274.00)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] 2,480,076.81[/TD]
[TD][/TD]
[TD] 2,480.00[/TD]
[/TR]
</tbody>[/TABLE]

 

[MrKowz]

Like this?

Excel 2013/2016
	A	B
1	Original Data	Formula
2	171,502.27	172
3	8,462,316.95	8462
4	6,225,692.58	6226
5	-273,633.00	-274
6	2,480,076.81	2480
Sheet3

Cell Formulas
Range	Formula
B2	=ROUND(A2/1000,0)

 

[CarinaO]

I would convert it by dividing it by 1000.

Or I found this

Format Numbers in Thousands and Millions in Excel Reports - dummies