I need a help on open office calc

Asked By marlin zee 0 points N/A Posted on - 03/07/2012

In an open office calc (spread sheet,) due to what reason does ##### appear in a cell?

I want to display number 205887413954210 in a cell,but it displays #####,please can anyone explain a method to display the actual number in the cell

• Status: Open
• Question Views: 973
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Marienade Mali

Go To Solution

Best Answer

Best Answer

Answered By Marienade Mali 5 points N/A #93909

I need a help on open office calc

Hello Marlin,

As you can see, the numbers you have inserted only show or contain number signs (#). There is only one reason why you are seeing this (this is applicable for numbers with decimal point). I’ll give you a short overview; if the number you’ve entered has spare numbers on the right of a decimal point in the setup, the digit automatically rounds off to as many decimal places as to how many you have setup. If there are further digits on the left of the decimal point than the setup, the extra digits will be displayed. But if it only show and contain number signs (#), no matter how ample numbers you’ve entered on it, numbers entered less than 1 which is beginning with a decimal point will never show numerically. For example: “.123456” will be presented as “######” but if you try “0.123456” it will show you the numbers you’ve entered. This problem can be solved by changing your settings. I hope this information is of good help.

About Marienade Mali

Questions
3

Answers
69

Best Answers
21

• Vote Up 0 Vote Down

• Posted on - 03/14/2012
• Question Category: MS Excel

Answered By theone1 0 points N/A #93911

I need a help on open office calc

Hi Marlin Zee

The ## that you have high lighted cell A1 can bee caused by a number of reasons

a)The number in the cell are too many for the cell to display

b) The formula in that cell produces an answer which is too wide for the cell to display.

c) The cell contain a negative number for a cell formatted

Example A negative value for a cell formatted to be a date cell. The date in Ms Excel should be positive value.

Follow the following steps to be able to display this number 

Type the number in the cell.

Right click and go to format cell 

At the format the number option choose number and then go to number option and the numbers will be displayed 

 

About theone1

Questions
0

Answers
40

Best Answers
18

• Vote Up 0 Vote Down

• Posted on - 05/19/2012
• Question Category: MS Excel