|
|
#1
06-09-2010, 01:09 PM
|
|||
|
|||
Can't calculate formulas
I have copied data from 8 workbooks into one, with 1 workbook per sheet then copied all on to a new spreadsheet merging all into 1 common format. But when I entered formulas, i.e. =LEFT(C122,FIND(" ",C122,1)) it will not calculate, it simply displays the formulas.
I'm not sure which version of Excel the workbooks were created in. Any help is appreciated. 
|
|
#2
06-09-2010, 01:39 PM
|
||||
|
||||
|
It's likely the cells where you entered the formulas were formatted for "text". Change the format to "General" and try again.
Cheers,
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Simple formulas | den hobbelder | Word | 1 | 02-26-2010 01:53 PM |
| Table formulas | markg2 | Word Tables | 0 | 01-15-2010 06:49 AM |
 Using Field Codes to Calculate 5 years from a Date
|
vandy | Word | 1 | 09-23-2009 11:32 AM |
| Word - Calculate and paste values from Excel sheet | Augf87 | Word | 1 | 07-06-2009 10:26 AM |
|
How to get cells to calculate time?
|
jrasche2003@yahoo.com | Excel | 2 | 02-09-2007 07:10 AM |
Mac OS X 
Microsoft Office 2004 for Mac
Linear Mode
