Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why does Concatenate formula show but not produce a cell result?
The result shows in the formaula calualtiuon but not in the actual cell. How
do the result to display in the cell? I have changed formating to all text, but I get nothing but formula. Won't calculate for some reason. Help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why does Concatenate formula show but not produce a cell result?
Format as general or number, select the cell, press F2 and then enter
-- Regards, Peo Sjoblom "Tom@WardAir" wrote in message ... The result shows in the formaula calualtiuon but not in the actual cell. How do the result to display in the cell? I have changed formating to all text, but I get nothing but formula. Won't calculate for some reason. Help! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why does Concatenate formula show but not produce a cell result?
And the formula is ......
-- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Tom@WardAir" wrote in message ... The result shows in the formaula calualtiuon but not in the actual cell. How do the result to display in the cell? I have changed formating to all text, but I get nothing but formula. Won't calculate for some reason. Help! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why does Concatenate formula show but not produce a cell result?
hi
Post your formula. regards FSt1 "Tom@WardAir" wrote: The result shows in the formaula calualtiuon but not in the actual cell. How do the result to display in the cell? I have changed formating to all text, but I get nothing but formula. Won't calculate for some reason. Help! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why does Concatenate formula show but not produce a cell result?
Have you tried CTRL+~ ?
-- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Tom@WardAir" wrote in message ... The result shows in the formaula calualtiuon but not in the actual cell. How do the result to display in the cell? I have changed formating to all text, but I get nothing but formula. Won't calculate for some reason. Help! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why does Concatenate formula show but not produce a cell result?
OOOPs: that is CTRL+` (no need for the shift)
-- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Tom@WardAir" wrote in message ... The result shows in the formaula calualtiuon but not in the actual cell. How do the result to display in the cell? I have changed formating to all text, but I get nothing but formula. Won't calculate for some reason. Help! |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why does Concatenate formula show but not produce a cell result?
say this is your formula
=A25*17 it'll show the result, not the formula if you put an apostrophe @ the beginning '=A25*17 it'll show the formula. but this is permanent, until you remove the apostrophe. if you just want to see it (& every other formula in the worksheet) temporarily, hit Ctrl + the backwards apostrophe (for lack of a better description) it's found above the Tab key, on the button with the tilde (little squiggly language thing - like manana in spanish has the tilde over the first "n"). hth susan On Dec 27, 3:51*pm, Tom@WardAir wrote: The result shows in the formaula calualtiuon but not in the actual cell. *How do the result to display in the cell? *I have changed formating to all text, but I get nothing but formula. *Won't calculate for some reason. *Help! |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why does Concatenate formula show but not produce a cell result?
oh, & if you use
Ctrl + ` & you want to put them all back to results, hit Ctrl + ` again. susan On Dec 27, 4:02*pm, Susan wrote: say this is your formula =A25*17 it'll show the result, not the formula if you put an apostrophe @ the beginning '=A25*17 it'll show the formula. *but this is permanent, until you remove the apostrophe. if you just want to see it (& every other formula in the worksheet) temporarily, hit Ctrl + the backwards apostrophe (for lack of a better description) it's found above the Tab key, on the button with the tilde (little squiggly language thing - like manana in spanish has the tilde over the first "n"). hth susan On Dec 27, 3:51*pm, Tom@WardAir wrote: The result shows in the formaula calualtiuon but not in the actual cell. *How do the result to display in the cell? *I have changed formating to all text, but I get nothing but formula. *Won't calculate for some reason. *Help!- Hide quoted text - - Show quoted text - |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why does Concatenate formula show but not produce a cell result?
Now that we have all tossed in our ideas, we don't really know much
about the problem. I'm not an MVP or excel expert, just a hacker ... but here's my experience just the same; There may be nothing wrong with the formula. One thing is that it depends on what type of data is being concatenated. I have learned that if the column width is not as wide as the results display, it won't all show up. It will drop whatever won't fit from right to left to the first space that will fit inside the column. For instance, if I A1= Joe and B1=McGillicuddy, then the formula =CONCATENATE(A1," ",B1,) will produce Joe McGillicuddy. But if the column isn't wide enough to display all of that, it will display "Joe" (without the quotes), and if you widen the column, the rest will display. Does that make sense? It seemed easier to explain before I started typing. --Jim On Dec 27, 4:05*pm, Susan wrote: oh, & if you use Ctrl + ` & you want to put them all back to results, hit Ctrl + ` again. susan On Dec 27, 4:02*pm, Susan wrote: say this is your formula =A25*17 it'll show the result, not the formula if you put an apostrophe @ the beginning '=A25*17 it'll show the formula. *but this is permanent, until you remove the apostrophe. if you just want to see it (& every other formula in the worksheet) temporarily, hit Ctrl + the backwards apostrophe (for lack of a better description) it's found above the Tab key, on the button with the tilde (little squiggly language thing - like manana in spanish has the tilde over the first "n"). hth susan On Dec 27, 3:51*pm, Tom@WardAir wrote: The result shows in the formaula calualtiuon but not in the actual cell. *How do the result to display in the cell? *I have changed formating to all text, but I get nothing but formula. *Won't calculate for some reason. *Help!- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why does Concatenate formula show but not produce a cell result?
Try text to column on that column. Click finish as soon as the wizard pops
up. That should return a result instead of the formula. "Tom@WardAir" wrote: The result shows in the formaula calualtiuon but not in the actual cell. How do the result to display in the cell? I have changed formating to all text, but I get nothing but formula. Won't calculate for some reason. Help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can excel produce text in a given cell as a result of a boolean operation? | Excel Discussion (Misc queries) | |||
Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
How do I get a cell to show the result instead of the formula? | Excel Worksheet Functions | |||
I can't get my concatenate formula results to show | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |