| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 how to stop emails from turning into hyperlinks? | Excel Discussion (Misc queries) | |||
| How can I stop Excel from turning the number ranges I enter (eg 1. | New Users to Excel | |||
| How do I stop Excel from turning November 2006 into Nov-06? | Excel Discussion (Misc queries) | |||
| stop (1) from turning into -1 | Excel Discussion (Misc queries) | |||
| How do I stop e-mail address from turning into link in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
