| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to copy just the number that a formula creates
ina sheet that has over 3000 rows and created a formula and copied to all
rows but I really just what the number the formula created. As I have to send this file to someone eles to upload into a new POS system and can't hve the formulas |
|
#2
|
|||
|
|||
|
Save your workbook. Copy all the cells with formulas, and keep your cursor
with all selected. Then hit Edit--paste special, values. Right-click the sheet tab and his Move or Copy. Copy the sheet tab to a new workbook. Don't save your old workbook and you won't lose your formulas. ******************* ~Anne Troy www.OfficeArticles.com "Paula" wrote in message ... ina sheet that has over 3000 rows and created a formula and copied to all rows but I really just what the number the formula created. As I have to send this file to someone eles to upload into a new POS system and can't hve the formulas |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy formula and get value instead | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Copy Paste of Formula Produces Incorrect Result | Excel Discussion (Misc queries) | |||
| Is it possible to change the "result of a formula" to a "number? | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Linear Mode
