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.

Original Data		What Formatt I need
171,502.27		172.00
8,462,316.95		8,462.00
6,225,692.58		6,226.00
(273,633.00)		(274.00)
2,480,076.81		2,480.00

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[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