error displaying large numbers

I formatted a cell as currency and tried to input a number larger than 1000 and the cell displays #######. Anyone know why this is and how to fix it?

Hi,

Resize column width. Either drag cell to fit or select column then format > column > autofit.

VBA Noob

Make the column wider or the font smaller ... or both

Regards

Trevor


"donkermazoid" <[email protected]>
wrote in message
news:[email protected]...
>
> I formatted a cell as currency and tried to input a number larger than
> 1000 and the cell displays #######. Anyone know why this is and how to
> fix it?
>
>
> --
> donkermazoid
> ------------------------------------------------------------------------
> donkermazoid's Profile:
> http://www.excelforum.com/member.php...o&userid=37207
> View this thread: http://www.excelforum.com/showthread...hreadid=569216
>