Excel 2003 mis-displaying a value as repeating itself

When a user enters a "1" and exits the cell, the cell 
displays as "111111111111111111111".
The cell is defined as Number, zero decimals, with (1234) 
formating.

Any clues to why this may be occuring, or is there a 
solution ?

Note: The spreadsheet was originally creating in Excel 
2000.
0
anonymous (74722)
9/10/2004 1:54:00 PM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
471 Views

Similar Articles

[PageSpeed] 9

Hi
maybe check 'Tools - autocorrection'

-- 
Regards
Frank Kabel
Frankfurt, Germany


J.D. Robbie wrote:
> When a user enters a "1" and exits the cell, the cell
> displays as "111111111111111111111".
> The cell is defined as Number, zero decimals, with (1234)
> formating.
> 
> Any clues to why this may be occuring, or is there a
> solution ?
> 
> Note: The spreadsheet was originally creating in Excel
> 2000.
0
frank.kabel (11126)
9/10/2004 3:10:19 PM
The alignment may be set to Fill:

Select the cell
On the Formatting toolbar, click the Align Right button


J.D. Robbie wrote:
> When a user enters a "1" and exits the cell, the cell 
> displays as "111111111111111111111".
> The cell is defined as Number, zero decimals, with (1234) 
> formating.
> 
> Any clues to why this may be occuring, or is there a 
> solution ?
> 
> Note: The spreadsheet was originally creating in Excel 
> 2000.


-- 
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

0
dsd1 (5911)
9/10/2004 5:42:05 PM
Reply:

Similar Artilces: