Trouble typing in numbers

  • Thread starter Thread starter zaink
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
How to subtract a number from a Mergefield? 0
Displaying zeros in cells 2
#VALUE on data copied from web page 4
Typed numbers are divided by 10 (Excel 2007) 2
In a sales quote sheet - sum totals by license type 1
Excel Typed text appears in wrong cell 0
Numbers showing Up Centered in Cell ? 1

Back
Top