Trouble typing in numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

zaink - 20 Jun 2006 19:59 GMT

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 :confused:

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

Signature

zaink

Reply to this Message

Gord Dibben - 20 Jun 2006 20:21 GMT

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

>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
[quoted text clipped - 4 lines]
>
>and sorry if i posted this in the wrong section, i am a newb :x

Reply to this Message

Larry S - 20 Jun 2006 20:24 GMT

Open up your column width

> 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
[quoted text clipped - 4 lines]
>
> and sorry if i posted this in the wrong section, i am a newb :x

Reply to this Message