Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Disappears, converts to a value
I have used Excel for over 10 years and have never encountered this
before. When I type in a very simple formula, "+28933/6" the formula converts to a value and will not hold the formula. In the same cell, if I use a "=" sign instead of the plus sign, it will stay a formula. I prefer using a plus sign because it's easier to quickly type. The cell above and below will accept the + sign and will hold the formula in tact. Why? Strange too is if I type in "+36000/6" in this same cell, the formula stays in tact (converting the plus to an equals sign) but if I type in "+24000/6" it converts to a value. Any ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Disappears, converts to a value
Maybe you always had transition formula entry checked, it is not Excel
defaults we are talking about. It's more of a leftover from when Lotus 123 was the major spreadsheet and MS catered to this. Go to toolsoptionstransition and check transition formula entry and it will be converted to a formula Default Excel behavior is to use the equal sign -- Regards, Peo Sjoblom wrote in message ups.com... I have used Excel for over 10 years and have never encountered this before. When I type in a very simple formula, "+28933/6" the formula converts to a value and will not hold the formula. In the same cell, if I use a "=" sign instead of the plus sign, it will stay a formula. I prefer using a plus sign because it's easier to quickly type. The cell above and below will accept the + sign and will hold the formula in tact. Why? Strange too is if I type in "+36000/6" in this same cell, the formula stays in tact (converting the plus to an equals sign) but if I type in "+24000/6" it converts to a value. Any ideas? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Disappears, converts to a value
Have a read on Dick's site:
http://www.dailydoseofexcel.com/arch...art-a-formula/ -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music " wrote: I have used Excel for over 10 years and have never encountered this before. When I type in a very simple formula, "+28933/6" the formula converts to a value and will not hold the formula. In the same cell, if I use a "=" sign instead of the plus sign, it will stay a formula. I prefer using a plus sign because it's easier to quickly type. The cell above and below will accept the + sign and will hold the formula in tact. Why? Strange too is if I type in "+36000/6" in this same cell, the formula stays in tact (converting the plus to an equals sign) but if I type in "+24000/6" it converts to a value. Any ideas? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Disappears, converts to a value
On Jul 9, 3:14 pm, "Peo Sjoblom" wrote:
Maybe you always had transition formula entry checked, it is not Excel defaults we are talking about. It's more of a leftover from when Lotus 123 was the major spreadsheet and MS catered to this. Go to toolsoptionstransition and check transition formula entry and it will be converted to a formula Default Excel behavior is to use the equal sign -- Regards, Peo Sjoblom wrote in message ups.com... I have used Excel for over 10 years and have never encountered this before. When I type in a very simple formula, "+28933/6" the formula converts to a value and will not hold the formula. In the same cell, if I use a "=" sign instead of the plus sign, it will stay a formula. I prefer using a plus sign because it's easier to quickly type. The cell above and below will accept the + sign and will hold the formula in tact. Why? Strange too is if I type in "+36000/6" in this same cell, the formula stays in tact (converting the plus to an equals sign) but if I type in "+24000/6" it converts to a value. Any ideas?- Hide quoted text - - Show quoted text - It was the transitions formula checkbox. That worked! Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro that converts xls to csv | Excel Worksheet Functions | |||
Excel converts UK to US dates | Excel Discussion (Misc queries) | |||
Excel converts formula to number | New Users to Excel | |||
= sum value turns to text and formula disappears | Excel Worksheet Functions | |||
What formula converts date to month only | Excel Discussion (Misc queries) |