What means "####" ?

bokzy · May 23rd, 2002, 10:20 AM

What should I check when I get "#####" value of cell ?

I tried Cell Properties, changing data type to numerical, but with no success.

Values are called from other workbook; and "#####" happens just to some cells - for e.g. on cell C34 ; next one (C35) is OK, although having same cell properties.

Any ideas ?

Mark O'Brien · May 23rd, 2002, 10:23 AM

It means that your column isn't wide enough to show all of the data correctly. Make the column wider.

JayKay · May 23rd, 2002, 10:26 AM

The '#####' error appears when the column is not wide enough to display the data in the cell. This problem only occurs when the cell contains numeric data, not text.

Cheers

JayKay

bokzy · May 23rd, 2002, 10:36 AM

Thanks, you're right.

Width of cell was the problem - Excel wanted to show me value error... Another mystery; cell is filled with data from other workbook, cell properties are OK... and it shows !Value ...

Mark O'Brien · May 23rd, 2002, 10:38 AM

What does the formula look like in the cell that returns #Value! and what is the formula in the cell that is being referenced?

This error typically means that the wrong type of argument was used in a function.

bokzy · May 23rd, 2002, 10:50 AM

Yes, that's strange...

Cell value is referenced to other workbook, using for example " ='C:ExcelC[a1.xls]'!Q56 "

Reference is OK (other cells are filled correctly), that other workbook exists, even data types are the same - so why some cell values can't be retrieved ?

bokzy · May 23rd, 2002, 11:00 AM

Btw...

One important thing - it happens only if source cell is empty ; when some number is entered, problem disappears.

But - why other cells respond to empty source by displaying standard "0" , and just a few of 'em display error message ?

Cell data types are the same.

Mark O'Brien · May 23rd, 2002, 01:43 PM

I haven't the foggiest idea. Perhaps one of the real spreadsheet experts can answer.

bokzy · May 24th, 2002, 12:43 AM

First I thought - maybe that file isn't readable all the time (it's on diskette)... but other cells are filled, so it's hardly a reason.

Anyone, some suggestions ?

Chris Davison · May 25th, 2002, 01:55 PM

Quote:

On 2002-05-23 09:50, bokzy wrote:

Yes, that's strange...

Cell value is referenced to other workbook, using for example " ='C:ExcelC[a1.xls]'!Q56 "

Reference is OK (other cells are filled correctly), that other workbook exists, even data types are the same - so why some cell values can't be retrieved ?

are you sure about that reference ?

c: isn't a diskette.... it's your hard drive

May 23rd, 2002, 10:23 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	It means that your column isn't wide enough to show all of the data correctly. Make the column wider. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

May 23rd, 2002, 10:38 AM	#5
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	What does the formula look like in the cell that returns #Value! and what is the formula in the cell that is being referenced? This error typically means that the wrong type of argument was used in a function. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

May 23rd, 2002, 01:43 PM	#8
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	I haven't the foggiest idea. Perhaps one of the real spreadsheet experts can answer. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 23rd, 2002, 10:20 AM	#1
bokzy New Member Join Date: May 2002 Location: Croatia Posts: 11	What should I check when I get "#####" value of cell ? I tried Cell Properties, changing data type to numerical, but with no success. Values are called from other workbook; and "#####" happens just to some cells - for e.g. on cell C34 ; next one (C35) is OK, although having same cell properties. Any ideas ?

May 23rd, 2002, 10:26 AM	#3
JayKay New Member Join Date: May 2002 Location: Leicester, UK Posts: 40	The '#####' error appears when the column is not wide enough to display the data in the cell. This problem only occurs when the cell contains numeric data, not text. Cheers JayKay

May 23rd, 2002, 10:36 AM	#4
bokzy New Member Join Date: May 2002 Location: Croatia Posts: 11	Thanks, you're right. Width of cell was the problem - Excel wanted to show me value error... Another mystery; cell is filled with data from other workbook, cell properties are OK... and it shows !Value ...

May 23rd, 2002, 10:50 AM	#6
bokzy New Member Join Date: May 2002 Location: Croatia Posts: 11	Yes, that's strange... Cell value is referenced to other workbook, using for example " ='C:ExcelC[a1.xls]'!Q56 " Reference is OK (other cells are filled correctly), that other workbook exists, even data types are the same - so why some cell values can't be retrieved ?

May 23rd, 2002, 11:00 AM	#7
bokzy New Member Join Date: May 2002 Location: Croatia Posts: 11	Btw... One important thing - it happens only if source cell is empty ; when some number is entered, problem disappears. But - why other cells respond to empty source by displaying standard "0" , and just a few of 'em display error message ? Cell data types are the same.

May 24th, 2002, 12:43 AM	#9
bokzy New Member Join Date: May 2002 Location: Croatia Posts: 11	First I thought - maybe that file isn't readable all the time (it's on diskette)... but other cells are filled, so it's hardly a reason. Anyone, some suggestions ?