Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special
I am trying to convert whole numbers in a spreadsheet to thousands. I was told there was a way to use the Paste Special Divide feature? Any thoughts? -- jcastellano ------------------------------------------------------------------------ jcastellano's Profile: http://www.excelforum.com/member.php...o&userid=30986 View this thread: http://www.excelforum.com/showthread...hreadid=519878 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special
just type 1000 (or whatever you need to do your conversion) en any cell, copy
it, open edit/paste special, and select divide or whatever funcion you like. I frequently use it to multiply by -1, changing negatives to positives....... You can also use it to convert numbers in Text format to number format by multiplying by 1. "jcastellano" wrote: I am trying to convert whole numbers in a spreadsheet to thousands. I was told there was a way to use the Paste Special Divide feature? Any thoughts? -- jcastellano ------------------------------------------------------------------------ jcastellano's Profile: http://www.excelforum.com/member.php...o&userid=30986 View this thread: http://www.excelforum.com/showthread...hreadid=519878 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special
Thousands? or Thousandths? If you want to convert 1234 to 1.234 then do this:
In a blank cell, enter 1000. Copy that cell Select your range of data to convert Paste Special selecting "Divide" Click OK You may then delete the 1000 you entered earlier If you do in fact want thousands, then use the same steps except use "Multiply" instead of divide. HTH, Elkar "jcastellano" wrote: I am trying to convert whole numbers in a spreadsheet to thousands. I was told there was a way to use the Paste Special Divide feature? Any thoughts? -- jcastellano ------------------------------------------------------------------------ jcastellano's Profile: http://www.excelforum.com/member.php...o&userid=30986 View this thread: http://www.excelforum.com/showthread...hreadid=519878 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special
In a blank cell type 1000, then copy, click on the cell(s) you want to divide
by 1000, then click Edit Paste Special, select Value and Divide. "jcastellano" wrote: I am trying to convert whole numbers in a spreadsheet to thousands. I was told there was a way to use the Paste Special Divide feature? Any thoughts? -- jcastellano ------------------------------------------------------------------------ jcastellano's Profile: http://www.excelforum.com/member.php...o&userid=30986 View this thread: http://www.excelforum.com/showthread...hreadid=519878 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special
If you mean you have, say 150,000 (in Cell A1)
In a blank cell (somewhere/anywhere) enter 1,000 Then select the cell with the 1,000 value and Ctrl+C (To Copy it).. Move your cursor and Click on A1, then at the Menu, Go to Edit, Paste-Special..., In the Dialog Box under Operation - click on the DIVIDE (radio button) and OK. Erase the content of the cell that you originally entered the 1,000 "jcastellano" wrote in message ... I am trying to convert whole numbers in a spreadsheet to thousands. I was told there was a way to use the Paste Special Divide feature? Any thoughts? -- jcastellano ------------------------------------------------------------------------ jcastellano's Profile: http://www.excelforum.com/member.php...o&userid=30986 View this thread: http://www.excelforum.com/showthread...hreadid=519878 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Paste Special and Paste Object | Excel Discussion (Misc queries) | |||
paste special | values should work with merged cells | Excel Discussion (Misc queries) | |||
Paste Special values only | Excel Worksheet Functions | |||
Paste Special Question | Excel Discussion (Misc queries) |