Excel Formula Showing "=#VALUE!"

Excel Formula Showing "=#VALUE!" In excel I have a cell with formula ("=......"). On the cell, I can clearly see the value of the formula, but the formula bar shows "=#VALUE!". How is that possible?
Asked by: Guest \| Views: 159

Total answers/comments: 2

Comments display order:

Guest [Entry]

Just double click on the cell and Press Shift+Ctrl+Enter.You will be able to see the values properly.

Guest [Entry]

methinks... the cell size isnt that big enough to fit the value.. try increasing the width