the answer dont display just the formula i input help

D

Dimetre

when i type the formula in the cell j5
=k3-100 it does not display changes when
i try to input a value in k3

the formula is still displayed at j5 and does not show the answer there.

help pls
 
M

Mangesh Yadav

Go to Tools > Options
View tab. In the windows option, unchek the box Formulas

Mangesh
 
N

Niek Otten

Your cell was probably formatted as text before you entered the formula.
Format as General or Number and re-enter the formula (F2, ENTER)

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
 

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

Newbie Help - IF Yes No Function 0
Subtotal and IF Formula 1
MS Project. Real progress of the project, % complete 1
Help with Formula 7
Insert formula even cells with data below it 6
Data Entry Form - Execute if value is not 0 5
AVERAGE NON-ZERO CELLS ACROSS SEVERAL WORKSHEETS IN SAME WORKBOOK 8
Need help with a formula 3

Top