View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Paul B Paul B is offline
external usenet poster
 
Posts: 709
Default HOW DO I CHANGE A FORMULA INTO AN ABSOLUTE NUMBER?

Sylviane, copy the cells and paste special valves
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"sylviane" wrote in message
...
how do I change a formula into an absollute number, so I can delete the
column where the number is.

I have a column in euros, a formula in another column to change it to
dollars.

I want the dollars column to be a number.

Thank you.