Dividing multiple cells by 1000

[Debbie]

I have a large spreadsheet and want to see the numbers in thousands. Is
there a way to highlight all the cells and divide them all by 1000 without
going into each cell?

 

[Teethless mama]

Enter 1000 in any blank cell and copy > select your range > right click Paste
Special > Divide > OK out

 

[Debbie]

Thanks. That was so easy.

Enter 1000 in any blank cell and copy > select your range > right click Paste
Special > Divide > OK out

 

[Teethless mama]

You're Welcome!

Thanks. That was so easy.

 

[Pred]

Try formatting your cells like this:
##0,