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
|
|||
|
|||
How do i stop Excel from turning a value into a formula?
All i want to do is write "+ dog" in a cell and it keeps turning it into a
freaking formula!! MAKE IT STOP!! ARGHH! |
#2
|
|||
|
|||
How do i stop Excel from turning a value into a formula?
enter '+ dog
note the ' apostrophe -- Greetings from New Zealand "Annetoinette" wrote in message ... All i want to do is write "+ dog" in a cell and it keeps turning it into a freaking formula!! MAKE IT STOP!! ARGHH! |
#3
|
|||
|
|||
How do i stop Excel from turning a value into a formula?
hi
preceed your entry with an apostrophe ie '+ Dog. you seem to be caught in up in lotus formulas. lotus formulas (not all) were proceeded with the plus sign and excel still has the lotus conversion built into it so that whenever it sees anything starting with a plus sign, it wants to convert it to a formula. by preceeding the entry with an apostophe, you would be telling excel ....."this is text, not a formula". this built in conversion thing goes back to when excel first came out and copied lotus in almost everything even down to the date bug that lotus had. oh well..... regards FSt1 "Annetoinette" wrote: All i want to do is write "+ dog" in a cell and it keeps turning it into a freaking formula!! MAKE IT STOP!! ARGHH! |
#4
|
|||
|
|||
How do i stop Excel from turning a value into a formula?
Precede it with an apostrophe.
-- David Biddulph Annetoinette wrote: All i want to do is write "+ dog" in a cell and it keeps turning it into a freaking formula!! MAKE IT STOP!! ARGHH! |
#5
|
|||
|
|||
How do i stop Excel from turning a value into a formula?
Or preformat the cell(s) as Text (Format|Cells|Number tab)
Annetoinette wrote: All i want to do is write "+ dog" in a cell and it keeps turning it into a freaking formula!! MAKE IT STOP!! ARGHH! -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|