Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Simplifies Problems in Formula String
I currently enter a simple formula such as =3968.67*(52/12) and Excel 2007
modifies the formula to =3968.67*4.33333333... How do I keep the problem in the parantheses in tact without Excel simplifying it for me? I tried the same formula on another machine with the same software and it doesnt' do it. I've searched through all of the options that I can think of and can't figure it out. Any help is appreciated! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Simplifies Problems in Formula String
Try doing the same thing in a new workbook in Excel 2007. Make sure all is
closed before trying in a new workbook. I'm wondering if the formula is already in another cell in the column that ecel isn't copy from thje other cell. Also I'm wondering if a personal.xls file is creating the problem. "burowyako" wrote: I currently enter a simple formula such as =3968.67*(52/12) and Excel 2007 modifies the formula to =3968.67*4.33333333... How do I keep the problem in the parantheses in tact without Excel simplifying it for me? I tried the same formula on another machine with the same software and it doesnt' do it. I've searched through all of the options that I can think of and can't figure it out. Any help is appreciated! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Simplifies Problems in Formula String
Interesting. It didn't do it in the new worksheet. I'll have to dig
further. Thank you! "Joel" wrote: Try doing the same thing in a new workbook in Excel 2007. Make sure all is closed before trying in a new workbook. I'm wondering if the formula is already in another cell in the column that ecel isn't copy from thje other cell. Also I'm wondering if a personal.xls file is creating the problem. "burowyako" wrote: I currently enter a simple formula such as =3968.67*(52/12) and Excel 2007 modifies the formula to =3968.67*4.33333333... How do I keep the problem in the parantheses in tact without Excel simplifying it for me? I tried the same formula on another machine with the same software and it doesnt' do it. I've searched through all of the options that I can think of and can't figure it out. Any help is appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Having problems with formula nested tables in Excel | Excel Worksheet Functions | |||
Having problems to add additional info to this string.... | Excel Worksheet Functions | |||
Having problems to add additional info to this string.... | Excel Worksheet Functions | |||
Converting a Formula stored as String to real Formula | Excel Worksheet Functions | |||
Formula to Replace or eliminate any sheetname(s) in formula string | Excel Discussion (Misc queries) |