Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas don't work after copy/paste from Lotus 1-2-3 97 (Excel 20
I have copy/pasted some workbooks from lotus into Excel 2003
(because excel do not read *.123-files) There are multiple spreadsheets in each workbook. All looks ok after some cleaning up,the formulas are not copied -but that is ok,having the numbers is enough for me to write new formulas. This is very simple spreadsheets, with only some sum-formulas and no connections between the sheets. I have formatted the cells containing numbers correctly (I think..) But it is now the odd thing happens; in the first spreadsheet the new formulas work fine. But in the next spreadsheet (in the same workbook) the formula returns 0. All help is much appreciated :-) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas don't work after copy/paste from Lotus 1-2-3 97 (Excel 20
Hi,
If your formulas are returning 0 then they are working. Check your data, if you haven't change de cell alignment after pasting then the numbers should be right aligned if they are left align then they're still in the form of text, format as General or numbers then try this: type the number 1 in a blank cell and copy it, next select your data and do a paste special/multiply. Good Luck Jean-Guy "Bardur" wrote: I have copy/pasted some workbooks from lotus into Excel 2003 (because excel do not read *.123-files) There are multiple spreadsheets in each workbook. All looks ok after some cleaning up,the formulas are not copied -but that is ok,having the numbers is enough for me to write new formulas. This is very simple spreadsheets, with only some sum-formulas and no connections between the sheets. I have formatted the cells containing numbers correctly (I think..) But it is now the odd thing happens; in the first spreadsheet the new formulas work fine. But in the next spreadsheet (in the same workbook) the formula returns 0. All help is much appreciated :-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting a Lotus 123 file to Excel | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Work book formulas | Excel Discussion (Misc queries) | |||
Excel should let me use formulas that refer to other cells w/ form | Excel Worksheet Functions | |||
How can I get EXCEL formulas to work in Works? | Excel Worksheet Functions |