DISPLAY IN MULTIPLES

  • Thread starter Faraz A. Qureshi
  • Start date
F

Faraz A. Qureshi

I ahve just received a file in which if I insert any character it is being
displayed in cotinuous form. For instance if I insert 2 it is being displayed
as 22222222222222... However 2 in the formula bar.

There is no code present and the format is also normal.

What might be causing this?

The sum on another sheet of the same cell is however being displayed
correctly.

Your help shall be highly obliged.

Thanx in advance.
 
F

Fev

I ahve just received a file in which if I insert any character it is being
displayed in cotinuous form. For instance if I insert 2 it is being displayed
as 22222222222222... However 2 in the formula bar.

There is no code present and the format is also normal.

What might be causing this?

The sum on another sheet of the same cell is however being displayed
correctly.

Your help shall be highly obliged.

Thanx in advance.
Click to expand...

Hi
Check the alignment in the Format cells is not set to Fill.
Regards
Heather
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Showing The Upcoming Days 1
HOW TO CATCH A DIFFERENT/INCONSISTENT FORMULA 3
CONDITIONAL FORMATTING FOR MORE THAN 3 CRITERIA? 1
Multiple Fields In Multiple Ranged Pivot Table 0
ALIGN DATA CELLS? 14
Excel Formula displays text of formula 2
V Lookup multiple entires 1
TWO HOTMAIL ACCOUNTS ON A SINGLE MACHINE 2

Top