| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas not working on converted file.
I have a file exported to Excel format however the formulas don't work on the
same and =2+2 is not working being displayed as if ' had been inserted, whereas there hasn't been. However the same formula works if a new column is inserted. Any clarification! -- Best Regards, FARAZ A. QURESHI |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas not working on converted file.
Hi
May be check cell format and change to number. HTH Cordially Pascal "FARAZ QURESHI" a écrit dans le message de news: ... I have a file exported to Excel format however the formulas don't work on the same and =2+2 is not working being displayed as if ' had been inserted, whereas there hasn't been. However the same formula works if a new column is inserted. Any clarification! -- Best Regards, FARAZ A. QURESHI |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas not working on converted file.
Thanx but no Pascal! I think had it been a problem of cell formatting an
error would have been shown as #value! rather than the formula itself being displayed as =2+2. -- Best Regards, FARAZ A. QURESHI "papou" wrote: Hi May be check cell format and change to number. HTH Cordially Pascal "FARAZ QURESHI" a écrit dans le message de news: ... I have a file exported to Excel format however the formulas don't work on the same and =2+2 is not working being displayed as if ' had been inserted, whereas there hasn't been. However the same formula works if a new column is inserted. Any clarification! -- Best Regards, FARAZ A. QURESHI |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas not working on converted file.
What I think Pascal means is that (almost certainly) the cell in which your
formula is sitting has been formatted as text. Change it to anything other than text (usually General is a good bet). Then re-enter the formula, either by retyping it, or by clicking in the formula bar to enter edit mode and then accepting the formula, or by going to edit mode by hitting F2 and again accept the formula. -- David Biddulph "FARAZ QURESHI" wrote in message ... Thanx but no Pascal! I think had it been a problem of cell formatting an error would have been shown as #value! rather than the formula itself being displayed as =2+2. -- Best Regards, FARAZ A. QURESHI "papou" wrote: Hi May be check cell format and change to number. HTH Cordially Pascal "FARAZ QURESHI" a écrit dans le message de news: ... I have a file exported to Excel format however the formulas don't work on the same and =2+2 is not working being displayed as if ' had been inserted, whereas there hasn't been. However the same formula works if a new column is inserted. Any clarification! -- Best Regards, FARAZ A. QURESHI |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2003 file converted to .xlsm file when save to network drive | Excel Discussion (Misc queries) | |||
| Formulas in Excel are not converted to Html when I save as htm? | Excel Discussion (Misc queries) | |||
| why do formulas stop working in an excel file? | Excel Discussion (Misc queries) | |||
| Date values are converted to formulas | Excel Discussion (Misc queries) | |||
| Can an Excel file be converted into Visio? | Excel Discussion (Misc queries) | |||
Linear Mode
