Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I CHANGE A FORMULA INTO AN ABSOLUTE NUMBER?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I CHANGE A FORMULA INTO AN ABSOLUTE NUMBER?
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 "sylviane" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to change number upwards. | Excel Discussion (Misc queries) | |||
If formula | Excel Worksheet Functions | |||
Is there a formula to change number value to the written value? | Excel Discussion (Misc queries) | |||
Is it possible to change the "result of a formula" to a "number? | Excel Discussion (Misc queries) | |||
Cannot change a formula | Excel Discussion (Misc queries) |