i can write a formula in cell but it can diaplay in formualbar.

D

Darshak

Can you help on " No display in formaulbar i can written in cell?"
Example ::
I can write in A2 cell
=A1+1
"=A1+1" diaplay in formulabar but i want to solve this problem "=A1+1" No
display in formulabar.
Please kindly Solve this problem.
 
S

Stefi

Cell formatting>Protection>Check "Hidden" box!

Regards,
Stefi

„Darshak†ezt írta:
 
B

Bernard Liengme

Is it possible the cell is formatted as text?
Delete the formula; format the cell General and re-type the formula, press
Enter to finish
best wishes
 
H

Howard31

Hi there,

Do like Stefi said but for this to work you need to protect the spreadsheet
 

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

Excel - Wich Function should I use? 1
VBA Coding Help for Beginner 0
Copy addition formula of non-consecutive horizontal cells 2
Display Sheet1: (A1:A10) value in Sheet2: (B1) 11
Excel does not accept text format! 0
Display entire number in cell 3
Can a formula do this? 1
Altered pasting functionality 3

Top