Divide selected cells by 1000

[Guest]

I have a spreadsheet with all values in $ and I need to convert it to
thousands ($K). Is there a way I can simply enter 1000 in a cell on my
spreadsheet, select all the values and divide them all by that cell?

 

[Domenic]

Sure, try the following...

1) Select an empty cell

2) Enter 1000

3) Edit > Copy

4) Select the range of cells containing the values

5) Edit > Paste Special > Divide > Ok

Hope this helps!

 

[Niek Otten]

Yes.

Enter 1000 in an empty cell. Edit>Copy.
Select your values.
Edit>Paste Special, check Divide

--
Kind regards,

Niek Otten

|I have a spreadsheet with all values in $ and I need to convert it to
| thousands ($K). Is there a way I can simply enter 1000 in a cell on my
| spreadsheet, select all the values and divide them all by that cell?

 

[Domenic]

That should be...

1) Enter 1000 in an empty cell

2) Select this cell

3) Edit > Copy

4) Select the range of cells containing the values

5) Edit > Paste Special > Divide > Ok

 

[Dave Peterson]

Or maybe keep the value, but give the cells a custom format of:

#,

(end with a comma)

 

[Niek Otten]

What a nice addition!

--
Kind regards,

Niek Otten

| Or maybe keep the value, but give the cells a custom format of:
|
| #,
|
| (end with a comma)
|
|
|
| Lowkey wrote:
| >
| > I have a spreadsheet with all values in $ and I need to convert it to
| > thousands ($K). Is there a way I can simply enter 1000 in a cell on my
| > spreadsheet, select all the values and divide them all by that cell?
|
| --
|
| Dave Peterson