Trouble typing in numbers

[zaink]

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

[Gord Dibben]

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

[Larry S]

Open up your column width

"zaink" <zaink.29psi0_1150830006.2973@excelforum-nospam.com> wrote in
message news:zaink.29psi0_1150830006.2973@excelforum-nospam.com...
>
> 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
>
>
> --
> zaink
> ------------------------------------------------------------------------
> zaink's Profile:
> http://www.excelforum.com/member.php...o&userid=35606
> View this thread: http://www.excelforum.com/showthread...hreadid=553780
>