Help with forumla showing up in cell... but not the sum

Rhill

New Member
Joined
Feb 7, 2005
Messages
4
Good morning all, I am currently trying to create a worksheet that will self populate based upon the data entered in another worksheet in the same Workbook. ON most of the cells that I ant the information to populate, this has worked. However, two cells only show the formula and not the data that is found on the previous worksheet. I have an image of this worsheet available if nyone could help, I would appreciate it. Thanks[/img]
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

shajueasow

Well-known Member
Joined
Oct 7, 2004
Messages
1,926
Hi Rhill,
Just check whether those cells have formula after an = sign. IF not add the = sign. Even after that you cannot get an answer please place a copy of your sheet
 

Rhill

New Member
Joined
Feb 7, 2005
Messages
4
Well, I have already checked to make sure there is a forula after teh = in both instances (There area total of 6 in the entire worksheet). How might I attach a picture to this post?
 

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,994
Are the cells showing the formulas formatted as text?

Also, pressing CTRL ~ (next to the 1) will toggle formula view on and off. But, that would apply more to having the whole worksheet show formulas, not a handful of cells.
 

Rhill

New Member
Joined
Feb 7, 2005
Messages
4

ADVERTISEMENT

Oaktree, I do have the cell formatted as text. 2 are showing the formula and 4 are showing the 'sum' of the formula.
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
Rhill said:
Oaktree, I do have the cell formatted as text. 2 are showing the formula and 4 are showing the 'sum' of the formula.

Run Edit|Find with Find What set to = and Replace With to =.
 

Rhill

New Member
Joined
Feb 7, 2005
Messages
4
Aladin, thank you and the rest of the folks here! Your tip did the trick!!! Have a great day.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,057
Messages
5,599,550
Members
414,316
Latest member
ExcelLee

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