Repeating pattern

[MarcoSpring]

Is there a formula by which I can divide 1000 (one thousand) in each field without wiping out the data already entered? data is already there I just need to divide all figures by 1000

	Period 1-2022	Period 2-2022	Period 3-2022	Period 4-2022
	JAN	FEB	MAR	APR
DESCRIPTION
REVENUE	=30000/1000	=50000/1000	=20000/1000	=40000/1000
Staff Salary Costs	=20000/1000	=15000/1000	=10000/1000	=12000/1000

 

[SpillerBD]

I am not sure about your caveat of "without wiping out the data already entered."
You can use Paste Special and apply a DIVIDE BY to a range of cells.

 

[MarcoSpring]

I need to divide all the existing values by 1000. so I have to insert this in every cell =/1000
Is there a formula by which I can copy and paste the cell by 1000 rather than manually amend it.

 

[Peter_SSs]

Is this what you mean? Test with some sample data.

Put 1000 in an empty cell
Now copy that cell that contains the 1000
Select the cells that you want divided
Right-click -> Paste special... -> Divide -> OK

 

[MarcoSpring]

thank you very much, it works

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.