SPREADSHEETS. When numbers in a range of cells are formatted as text, how can they be reformatted numeric?
102604
I am assuming that you are using Excel.  Highlight your cells and click Format->Cells on menu bar.  Change from text to Number.
663190
format-->cells-->custom \ntype in ##,##,##,##
623394
IsNumeric will tell you if a value being passed into it can be converted into a number, were you to try to run Decimal.Parse on it. You might use it like this:\n\nFunction Translate(Foo as String) As Decimal\n    if IsNumeric(Foo) = True then\n      Return Decimal.Parse(Foo)\n    Else\n      Return 0\n    End if\nEnd Function
150023
if the cell is specifically formatted to be "text", then that can happen.  Go to "Format", "Cell", then change the format to "General"\n\nI just went to Excel and check it, and "text" format caused the problem and putting it to "general" and retyping the equation fixed the problem.
1099390
Use Number formatting for those cells rather than General.  The General format will force exponent for anything larger than 1e+11 (or 100,000,000,000).  I'm not sure why your number drops the 5 like you describe, but it may just be a formatting issue.  After changing your format to Number, you may have to resize your column so that, in case it does show an exponent, it will show the entire number.
898862
Format text in cells that contain errors so that they don't show\n\nSelect the cells that contain the error value. \nOn the Format menu, click Conditional Formatting. \nIn the box on the left, click Formula Is.\n\nIn the box on the right, type =ISERROR(reference), where reference is a reference to the cell that contains the error value. \nClick Format, and then click the Font tab.\n\nClick Format. \nIn the Color box, select white.
1118036
You want to use conditional formatting.  From the menu bar select Format then from the resulting menu select Conditional Formating.  You select the conditions for when you want the color to change.  You can set more than one condition.  Use the Format button to format the cell or range of cells to whatever color or font you would like them when that condition is met.\n\nOne thing to note, Excel will keep the conditional formating for that range of cells in place even if you manually try to color the cell.  Unless you remove the conditional formatting, it will keep the conditional formating in place.  To remove the conditional formating, select the cell or cells that you want to remove the conditional formating from and go to Conditional Formating again.  Click delete, then check the conditions that you want to delete.  Click OK to get out of the first window, then click OK again to get out of the second window.
1065789
Make sure source works. and destination s.has cells selected as numbers. I assume you know how to do it. But here it is in case:\nSelect column. Right click it and go to format cells.Stay in number tab and select number. \nIt should work fine.
110093
Copy then paste the value only.  From Excel Help:\n\n"Replace a formula with its result\nYou can "freeze" a formula so that it no longer recalculates by replacing a formula with its calculated value. If you want to freeze only part of a formula, you can replace only the part you don't want to recalculate.\n\nReplace a formula with its calculated value\n\nCaution   When you replace a formula with its value, Microsoft Excel permanently removes the formula. If you accidentally replace a formula with a value and want to restore the formula, click Undo  immediately after you enter or paste the value.\n\nSelect the cell that contains the formula. \nIf the formula is an array formula, select the range that contains the array formula. \n\nHow? \n\nClick a cell in the array formula. \nOn the Edit menu, click Go To. \nClick Special. \nClick Current array. \nClick Copy . \nClick Paste  on the Standard toolbar. \nClick the arrow next to Paste Options , and then click Values Only. \nReplace part of a formula with its calculated value\n\nCaution   When you replace part of a formula with its value, it cannot be restored.\n\nClick the cell that contains the formula. \nIn the formula bar , select the portion of the formula you want to replace with its calculated value. When you select the part of the formula you want to replace, make sure to include the entire operand. For example, if you select a function, you must select the entire function name, the opening parenthesis, the arguments, and the closing parenthesis. \nTo calculate the selected portion, press F9. \nTo replace the selected portion of the formula with its calculated value, press ENTER. \nIf the formula is an array formula, press CTRL+SHIFT+ENTER. "
942420
It depends on what kind of numbers you want it to display. For example, say you want to check a cell (A1) and put a 90 if it's greater than or equal to 90, 80 if it's less than 90, then you'd do this:\n\n=IF(A1>=90,90,80)\n\nYou can imbed IF's inside as well. For example if you wanted to put 90 for values between 90 and 100, 80 for between 80 and 90, and so on to 60 for 60 or below, you'd do this:\n\n=IF(A1>=90,90,IF(A1>=80,80,IF(A1>=70,70,60)))\n\nYou can pretty much put any statement in an IF. I use the above a lot as a teacher. All the examples you saw, if you just replace the letters with what you want, it should work.\n\nHope that helps!
489379
All that usually means is that you have entered a number value, and the column width is too small for Excel to display it.\nIncrease the column width and the spreadsheet will display your numerical value properly.
718467
go to the Format column, and then go to Cells...\nIn that box, pick TEXT. it will display your number exactly how it is written.
738891
A simple way is to make the cell a colour until it is filled with an amount.  You can do this through conditional formating under  Format.  For example if you say Cell value is equal to 0 then  format the cell Red.  If you put in a value other than 0 the red will disappear.
834986
Use conditional formatting\n\nhttp://www.contextures.com/xlCondFormat01.html
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.
792191
If you really want them to be numbers, then change the format of the cells. Use the number format "0000#" (or however many zeros you want).\n\nHowever, VLookup will not match the leading zeros in this case because the internal format of the numbers will be mathematical not textual. If you want to store the numbers as text (for instance, if they are ID numbers) then preface them with ' when you enter them. This tells Excel not to evaluate the cell.
921289
If you are only trimming the 0 from the front ( which is what I get from your description ) just use the RIGHT function. Add a column to the right of your data and use this formula.\n\n=RIGHT(A1,LEN(A1)-1)\n\nYou will need to change the A1 to match the reference of your first cell; then just copy the formula alongside your data.\n\nTo eliminate the formulas once the 0s are gone, just select the data in the new column, Copy, then Paste Special... over your original data. Now you can delete the new column.