Trouble typing in numbers

Z

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

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
 
Top