I have a column of numbers that is made from formulas. Is there a way to
keep those numbers and remove the formulas so that it is just a column of
numbers.
I have a column of numbers that is made from formulas. Is there a way to
keep those numbers and remove the formulas so that it is just a column of
numbers.
Copy the column, then Paste Special with Values only over the same column.
-Simon
"CJ" wrote:
> I have a column of numbers that is made from formulas. Is there a way to
> keep those numbers and remove the formulas so that it is just a column of
> numbers.
That was so easy. Thanks for the help.
"SimonCC" wrote:
> Copy the column, then Paste Special with Values only over the same column.
>
> -Simon
>
> "CJ" wrote:
>
> > I have a column of numbers that is made from formulas. Is there a way to
> > keep those numbers and remove the formulas so that it is just a column of
> > numbers.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks