In Excel a cell formatted "currency" shows "######" help!
 

I have formatted currency cells but in some when entering an amount "######"
this fills the cell once I press enter. The same amounts are input fine into
other cells. I have tried to reformat but that is not the porblem. What do
I do?

In Excel a cell formatted "currency" shows "######" help!
 

Have you tried widening the column?
Regards,
Alan.
"llveda" wrote in message
...
I have formatted currency cells but in some when entering an amount
"######"
this fills the cell once I press enter. The same amounts are input fine
into
other cells. I have tried to reformat but that is not the porblem. What
do
I do?

In Excel a cell formatted "currency" shows "######" help!
 

Hi there,

If you read the Help files, the two causes for the "#######" is either the
column width is not wide enough to support the characters displayed in the
cell or a negative time value.

HTH

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM



"llveda" wrote in message
...
I have formatted currency cells but in some when entering an amount
"######"
this fills the cell once I press enter. The same amounts are input fine
into
other cells. I have tried to reformat but that is not the porblem. What
do
I do?