| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel , How do I turn off the math funtions?
I have set-up a inspection spread-sheet. I need to be able to insert funtions
without them being figured. ex. I insert +.005. The plus sign disappears. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In Excel , How do I turn off the math funtions?
Don't start with a plus.
or preformat your range of cells as text or Start with your entry with an apostrophe '+.005 randrews13 wrote: I have set-up a inspection spread-sheet. I need to be able to insert funtions without them being figured. ex. I insert +.005. The plus sign disappears. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
In Excel , How do I turn off the math funtions?
Try formatting the cells as text before you type in your data.
-- "randrews13" wrote in message ... I have set-up a inspection spread-sheet. I need to be able to insert funtions without them being figured. ex. I insert +.005. The plus sign disappears. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How do turn on gridlines in Web page preview for a Excel XP HTML | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| how to turn off email header with excel workbook | Excel Discussion (Misc queries) | |||
| Turn off Assistance pane in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
