When I click a cell in Excel it prompts "Too many different cell formats", how can I edit the cell content?
402496
It is not Excel problem, it is most likely Windows problem,\nTry the following procedurs:\n1- Clear the temporary internet files, go to Control panel > Internet options > Delete files\n2- Clear history and cookies (Same place)\n3- Delete temp files, go to C: > documents and settings > YOURUSERNAME > Local settings > Temp\nand clear all its content, if you could not find "Local Settings" just type it in the enda of the line in address bar in YOURUSERNAME.\n4- Restart computer.\n5- Mark me as best answer if it is helped you.\n\nThanks
611449
When you save an excel file into htm format you are going to loose you formula's. You can try to rename the file back to test.xls and see if that converts it. chances are when you open it your going to throw an error on the formulas for the cells. just ignore it and see if you get back your data.
713558
right click with the pointer over that cell. Choose format cells. choose the patterns tab and there you go. Choose your color and you are done.
1080679
Try selecting all of the text you wish to reformat, pressing the right mouse button over the selected text and then select format.  That's how I would do it on a PC, it's probably something similar on a MAC.
326425
Make sure you have a color printer defined and set as default printer in excel. Wierd, I know!
400717
To select all errors on a worksheet, Edit, Go To, Special. Select formulas, and unceck all formula options except 'errors'. Click OK.\n\nNow you have all the error cells selected, you can change the background color to something easy to find, like yellow. All the errors will then be in yellow.
311771
Right click in any menu toolbar, it will show you the common toolbars... select the bottom option "Customize"... In the toolbars TAB look for and select "Worksheet Menu Bar" this is the one that contein file, edit, view, insert, format ....etc\n\nYou're done!\n\nPlease vote!
490179
If Ed answer was not the one you liked, you may see the "Value" in Excel Help, f this is what you asked for,\nThis Value is reffered to the result of a cell function.\nMeans\nWhen you enter =4*5 in a cell this "=4*5" is the cell content, while the "20" that appears in the cell is the "Value" of this cell\n\nHope this is what you asked for..\n\nXLMan
919319
Try going to the Tools menu and choosing Options.  Under the View tab, in the Formatting Marks section, make sure that there are no boxes checked and click OK.
222431
If it's the information you need in Excel, open both files in their respective applicatioin, go to the Word documents select all, copy.  Move to the Excel document and Paste.  You will not have all the formating in Word but it will be editable.  You can also use Paste Special and choose other formats to paste in.  Some of these may be uneditable but look like the Word document.
459913
Excel has that limitation.\n\nLook into using MS Access instead.
708937
Format, Cell, Number, offers a choice to have the result in red.\nThe #N/A suggests that there is something wrong with your table - like there's a gap somewhere.  Excel's Help offers guidance.\n-MM
69108
uhmm.. download openoffice and unistall microsoft office, open ofice is better to convert any format into other...\nthats what i do...
525741
You probably took some action that made the column width change (there are any number of ways this can happen).\n\nThe solution is (assuming you're using Excel or a similar spreadsheet) is to select the columns that have changed (click on the column letter and hold down the mouse button and drag across the top until all the columns you want to change have been highlighted).  Next, right click, select column width, then enter a vaule less than that shown (you can experiment with values until you get the width you want).  Finally, hit enter.
1186574
Format the column as "Text" instead of as "General". When it is input as a number, it is limited to the precision of an integer or double integer. When it is text, any math performed on it will be at the limit of precision, however the digits will display on the sheet.\n\nIf you are typing in numbers, you can force the cell to be treated as text by typing an apostrophe (') first.\n\nInformation about how Excel handles numbers can be found here: http://support.microsoft.com/kb/78113/en-us
573840
Best is to format the cell by right clicking on it....and choosing format cells....under Number tab choose Custom...and type format as 000 (no. of zeros upto the digits u require)....and enter..\n\nBy doing so ull be storing numbers as numbers and with leading zeros....\n\nI dont agree with typing '048 as it stores numbers as text\n\n\nhope this clarifies ur doubt
392220
1.  Mark the applicable column or cell.\n2.  Choose "Format" drop-down menu from the top menu.\n3.  Select "Cells"\n4.  On the TAB "Number" (first TAB), choose the option "Number" (the default is General)\n5.  Select the decimal places as "2"\n6.  Click on OK\n\nAll numbers in the selected cells will now be shown with two decimal places