Sidebar Sidebar
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

Excel functions not working

J

jim44314

macrumors newbie
Original poster
Apr 30, 2012
1
0
Concatenate function is not working. Function Builder indicates the result I am looking for but the cell containing the function is displaying the formula and not the result. I have formatted all of the effected cells as "General." The calculation preference is set at "Automatically."

Many thanks.
 
jim44314 said:
Concatenate function is not working. Function Builder indicates the result I am looking for but the cell containing the function is displaying the formula and not the result. I have formatted all of the effected cells as "General." The calculation preference is set at "Automatically."

Many thanks.
Click to expand...
After you format the cell where the formula is to General, double-click in the cell to edit the formula, then press enter.
 
You must log in or register to reply here.
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.
Top Bottom
Back