Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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) |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
abdualmohsn | Excel Discussion (Misc queries) | |||
Auto filter not displaying number of results in status bar. | Excel Discussion (Misc queries) | |||
Sorting and displaying different results | New Users to Excel | |||
Stopping Charts Displaying Zero Results | Charts and Charting in Excel | |||
displaying results and not formulas | Excel Worksheet Functions |