| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Converting formulas to value
I have a workbook in Excel 2007 that contains cells which are external
references of another source. This is a monthly workbook that I now wish to save and transfer to a disk for storage. I believe that I will lose the amounts shown if the formulas are not converted to value first. If this is correct how can I convert the formulas to value? Thanks very much for your help. Gene L. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Converting formulas to value
"Gene L." wrote in message
... I have a workbook in Excel 2007 that contains cells which are external references of another source. This is a monthly workbook that I now wish to save and transfer to a disk for storage. I believe that I will lose the amounts shown if the formulas are not converted to value first. If this is correct how can I convert the formulas to value? Thanks very much for your help. Gene L. Copy-Paste Special-Values |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Converting formulas to value
That's it- Many thanks
Gene L. "Gordon" wrote in message ... "Gene L." wrote in message ... I have a workbook in Excel 2007 that contains cells which are external references of another source. This is a monthly workbook that I now wish to save and transfer to a disk for storage. I believe that I will lose the amounts shown if the formulas are not converted to value first. If this is correct how can I convert the formulas to value? Thanks very much for your help. Gene L. Copy-Paste Special-Values |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting a date to a text field w/o converting it to a julian da | Excel Worksheet Functions | |||
| Cells converting ###s to formulas | Excel Discussion (Misc queries) | |||
| Short cuts for converting formulas to values | Excel Discussion (Misc queries) | |||
| Converting text to formulas | Excel Worksheet Functions | |||
| converting concatenated text strings into formulas | Excel Worksheet Functions | |||
Linear Mode
