Dividing multiple cells by 1000
Try formatting your cells like this:
##0,
"Debbie" wrote:
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?
|