This usually indicates the cell is not wide enough to show the number.

Widen the column manually by dragging the edge or Format>Column>Autofit.


Gord Dibben MS Excel MVP

On Tue, 20 Jun 2006 13:59:37 -0500, zaink
<zaink.29psi0_1150830006.2973@excelforum-nospam.com> wrote:

>
>i made a spreadsheet for work so they can type money ammounts in.. and
>it worked the first few days but now when people try to type in numbers
>it show up as "########" even when i had SUM formulas it worked fine now
>it shows up as same thing
>
>not sure if it matters but the format of all the numbers is currency
>
>
>
>and sorry if i posted this in the wrong section, i am a newb :x