I keep getting ##### in a cell when I type in a dollar figure.

  • Thread starter Thread starter Sunny D
  • Start date Start date
S

Sunny D

I delete the contecnts, but the cell shows ####, but the dollar figure shows
up in the prompt.
 
if you will double click on the right edge of the column that is giving you
trouble, it should expand to be large enough to show all the number.
 
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

How do I create formulas between worksheets? 5
text and formula in the same cell - how do I format this cell?? 4
Combining Text and Dollar Value 3
Is there a formula to change number to word. Ex. $10 > ten dollar 2
Add cells based on critera 3
Sum is not correct after adding calculated fields 4
formatting a cell 2
Displaying results in dollars 3

Back
Top