LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Numerical Data Appears with - Sign

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I run a regression on data that is not numerical? NG Excel Worksheet Functions 4 April 3rd 23 07:44 PM
Pivot Table Data-Deleted Data still appears CrimsonPlague29 Excel Discussion (Misc queries) 8 January 18th 08 05:52 PM
Plus sign no longer appears when cell is selected Ashley Excel Discussion (Misc queries) 2 December 14th 06 06:42 AM
How do I total non-numerical data asg2307 New Users to Excel 2 December 27th 05 09:27 PM
ENTER DATA EXCELL SO RELATED DATA APPEARS VICKIO66 Excel Worksheet Functions 2 August 23rd 05 01:16 AM


All times are GMT +1. The time now is 04:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"