![]() |
functions are not displaying the results
For some reason, my functions are not displaying their results in the
cells. All that shows up is the function itself. What am I missing? Here's a simple example of a concatenate function to combine two columns that contain the city and the state into one column. This is also what is displaying in the cell - what should have displayed was Peoria, IL =CONCATENATE(G3,", ",H3) |
functions are not displaying the results
Perhaps the cell is formatted as text, if so, change the format to General.
Or you may have formula view, OptionsToolsView and check the Formulas checkbox. -- HTH Bob Phillips (remove nothere from email address if mailing direct) wrote in message ups.com... For some reason, my functions are not displaying their results in the cells. All that shows up is the function itself. What am I missing? Here's a simple example of a concatenate function to combine two columns that contain the city and the state into one column. This is also what is displaying in the cell - what should have displayed was Peoria, IL =CONCATENATE(G3,", ",H3) |
All times are GMT +1. The time now is 09:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com