If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Now I can't get the Text Format to stick in a cell
Hello,
Recently I had a problem getting Excel to recognize as formula as such when the cell had been formatted as text before the formula was entered. Now, I can't get the Text Format to stick! I set the cell(s) to text. The copy a string of digits from a web page, paste it into the cell and the format changes to General!!! I go ahead and reset the cell to text but I why should I have to do this? It truly seems as though the details are not being looked at! Sheesh! |
#2
|
|||
|
|||
Now I can't get the Text Format to stick in a cell
Hi
Instead of just pasting, rather PasteSpecial -- Values If this helps please click "Yes" "BS" wrote: Hello, Recently I had a problem getting Excel to recognize as formula as such when the cell had been formatted as text before the formula was entered. Now, I can't get the Text Format to stick! I set the cell(s) to text. The copy a string of digits from a web page, paste it into the cell and the format changes to General!!! I go ahead and reset the cell to text but I why should I have to do this? It truly seems as though the details are not being looked at! Sheesh! |
Thread Tools | |
Display Modes | |
|
|