Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a quick/easy way to get excel to replace ALL forumulas the numerical result in one step?
Suppose I had spreadsheet with hundreds of numbers...
I have looked in excel help to about converting to the number result (select copy, then paste-special the 'number-only' value over the same cell) ps - big thanks to people who take the time to reply to my posts. I am still learning. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a quick/easy way to get excel to replace ALL forumulas thenumerical result in one step?
Select the range to do this to (include as many pre-existing values as you
want--it won't hurt them), then do that edit|copy, edit|paste special|values. I think that this is the quickest way. wrote: Suppose I had spreadsheet with hundreds of numbers... I have looked in excel help to about converting to the number result (select copy, then paste-special the 'number-only' value over the same cell) ps - big thanks to people who take the time to reply to my posts. I am still learning. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a quick/easy way to get excel to replace ALL forumulas the numerical result in one step?
CTRL + a(twice in 2003) to select all cells.
Copy and in place Paste SpecialValuesOKEsc Turn on the macro recorder to get a macro you can assign to a button or shortcut key combo. Gord Dibben MS Excel MVP On Thu, 20 Sep 2007 14:58:49 -0700, wrote: Suppose I had spreadsheet with hundreds of numbers... I have looked in excel help to about converting to the number result (select copy, then paste-special the 'number-only' value over the same cell) ps - big thanks to people who take the time to reply to my posts. I am still learning. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I replace forumulas with the round function in one go | Excel Discussion (Misc queries) | |||
Can I link a result from Quick Book Pro 2006 to an Excel file? | Excel Discussion (Misc queries) | |||
Can I link a result from Quick Book Pro 2006 to an Excel file? | Excel Discussion (Misc queries) | |||
Quick and easy labeling | Excel Discussion (Misc queries) | |||
Quick and easy | Excel Worksheet Functions |