how to copy just the number that a formula creates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
How to subtract a number from a Mergefield? 0
Excel Drag autofill only part of formula 3
Excel Sequential Numbering System 0
Create a formula by joining text and the value from a formula 3
copy formula to filtered cells only 4
Array formulas 3
Formula to add two spaces into a number stored as text 3

Back
Top