Excel formula to number

  shellship 12:28 07 Nov 08
Locked

I used to be able to do this but can't remember how - despite looking in Excel Help. I have a column of figures that are the result of a formula. I want to add a new column that shows these results as a number only that I can use elsewhere. Is my expert VoG, or anyone else, around today, please.

  2neat 12:41 07 Nov 08

have a look here click here

  Picklefactory 12:52 07 Nov 08

Could you qualify what you mean by 'use elsewhere', it could make a difference, I think.

  mgmcc 12:56 07 Nov 08

"Copy" the contents of the column which uses formulae, and use "Paste Special" to paste in only the "Values".

  VoG II 13:04 07 Nov 08

You should be able to use the results of a formula in another formula without having to copy the values elsewhere.

  shellship 15:10 07 Nov 08

Thanks all. mcmcc got it. I still forget about "Paste Special".

This thread is now locked and can not be replied to.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now