Excel formula to number

  shellship 12:28 07 Nov 2008
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 2008

have a look here click here

  Picklefactory 12:52 07 Nov 2008

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

  mgmcc 12:56 07 Nov 2008

"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 2008

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 2008

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

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

Elsewhere on IDG sites

Alienware 17 R4 2017 review

Illustrator Sylvain Tegroeg created thousands of intricate line drawings for the mobile game…

Best iPad buying guide 2017

Comment télécharger une application indisponible en France ?