Stupid Question - Cell displays formula

xcellnoob

Board Regular
Joined
Apr 6, 2005
Messages
188
Why is this happening?
I have a date in cell A1 Say 5/08/2006
I want cell A2 to display next day. 5/09/2006
I type in cell A2 =A1+1
A2 displays =A1+1 instead of 5/09/2006
What the heck?
I can't seem to get around it.
Help is much appreciated.
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

xcellnoob

Board Regular
Joined
Apr 6, 2005
Messages
188
negative. It doesn't appear to be a formatting issue. I thought it didn't matter the formatting if you have an "=" in front the format applies to the result. I'm not getting the result, I am getting the actual formula which is just plain stupid.
**Disclaimer - This is an inherited spreadsheet. **
 

Rob Lanctot

New Member
Joined
Aug 3, 2005
Messages
24

ADVERTISEMENT

Just throwing in a possiblity - even if you change a cell that is formatted as text to 'general' for example, if there is any entry in the cell it won't be changed until the info is re-entered. Try: selecting the cell, hitting <F2>, then hitting enter (after changing the cell format to general).

Hope that helps!
Rob
 

Rob Lanctot

New Member
Joined
Aug 3, 2005
Messages
24
That was supposed to read:

Try: selecting the cell, hitting F2, then hitting enter (after changing the cell format to general).
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
Select the formula-showing cells.
Run Edit|Replace.
Set Find What to: =
Set Replace With to: =
Click on the Replace All button.
 

Forum statistics

Threads
1,141,483
Messages
5,706,649
Members
421,460
Latest member
Taamrak

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top