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?

Have you tried widening the column?
Regards,
Alan.
"llveda" <[email protected]> wrote in message
news:[email protected]...
>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?

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" <[email protected]> wrote in message
news:[email protected]...
>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?