HOW DO I CHANGE A FORMULA INTO AN ABSOLUTE NUMBER?

S

sylviane

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.
 
P

Paul B

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
 
V

Vikas Kumar

Hi sylviane
Select the cell which contains formula. then follow the steps below:

1. "COPY"(ctrl+c) the cell/cells
2. "Right" click(mouse button) being active/selected in the same cell/cells
3. Select the "Paste Special"
4. select the option "Value/Values" from the option box.
5. "OK"

Hoping this could help you to avoide #REF/#N/A kind of errores.

Regards
Vikas Kumar
[email protected]
 
Top