How can I copy data produced by a formula, not the formula?

J

JBrewster

My worksheet has a column#3 of the number of days, produced b
subtracting date in column1 from date in column2. Some on this foru
helped me with getting this done. The column contains about 30 rows
and shows as a number representing the number of days. I want to us
the data here in Column3 to determine the interest on a loan made fo
each of these dates. When I try to use the loan amount for each dat
times a column of daily interest amount, .005/365, times the number o
days column, the result shows as a date. How do I make the number o
days showing from this column3 available to use in my calculation? Wha
do I do to copy the data, not the formula? Thanks so much
 
S

Stan Brown

My worksheet has a column#3 of the number of days, produced by
subtracting date in column1 from date in column2. Some on this forum
helped me with getting this done. The column contains about 30 rows,
and shows as a number representing the number of days. I want to use
the data here in Column3 to determine the interest on a loan made for
each of these dates. When I try to use the loan amount for each date
times a column of daily interest amount, .005/365, times the number of
days column, the result shows as a date. How do I make the number of
days showing from this column3 available to use in my calculation? What
do I do to copy the data, not the formula? Thanks so much.

Highlight the source cell, Ctrl-C to copy. Click into the
destination ell, Alt-E, S, V for edit/paste special/values.
 

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

Top