LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Having problems with formula nested tables in Excel Chad Excel Worksheet Functions 6 March 16th 09 01:53 PM
Having problems to add additional info to this string.... Carlo Excel Worksheet Functions 0 April 2nd 08 03:48 PM
Having problems to add additional info to this string.... Greg Wilson Excel Worksheet Functions 2 April 2nd 08 04:30 AM
Converting a Formula stored as String to real Formula BlueD Excel Worksheet Functions 3 January 14th 08 07:48 PM
Formula to Replace or eliminate any sheetname(s) in formula string EagleOne Excel Discussion (Misc queries) 0 September 20th 06 06:36 PM


All times are GMT +1. The time now is 03:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"