Why is that happen ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
i format all cells in D,E,F and G to currency and try to typ for example
1459.70 in cell D but it returns just this ########.
Can someone tell me why ?
Thank you in advance
Unal
 
Try making the column wide enough to display all of the digits.

--

Hi,
i format all cells in D,E,F and G to currency and try to typ for example
1459.70 in cell D but it returns just this ########.
Can someone tell me why ?
Thank you in advance
Unal
 
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

Scrabble Value calculation for Welsh words 0
Exist a function to... 3
IF Function 4
Lookup Across Multiple Rows / Columns 5
Excel Countifs/Sumproduct with mutil Or statement 3
Copy columns, but not hidden ones 3
Sumproduct not returning expected results 7
Returning multiple text data into 1 column from many column entrie 1

Back
Top