Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
MS Office Excel 2003.
For some unknown reason, each time that I enter a number in a cell, it appears with a - (hyphen) in front of the number after ENTER or moving out of that cell. This happens throughout a multisheet workbook. The fx line shows only the number: no hyphen. Several sheets had already existed in this workbook, and I added an additional sheet with dates located within Column A. Then I copied sequential date groups onto separate newly added worksheets. I added a new worksheet, and this abnormality occurs within the new sheet also, but not within a new workbook. Why is the data being entered as a negative number ? It appears that the cells seem to be expecting a telephone number format: (45522217) 421-2214 appears when I increase the number of digits within the entered number. How do I turn off this formatting ? I added available Add-ins just yesterday. TNX. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I run a regression on data that is not numerical? | Excel Worksheet Functions | |||
Pivot Table Data-Deleted Data still appears | Excel Discussion (Misc queries) | |||
Plus sign no longer appears when cell is selected | Excel Discussion (Misc queries) | |||
How do I total non-numerical data | New Users to Excel | |||
ENTER DATA EXCELL SO RELATED DATA APPEARS | Excel Worksheet Functions |