Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.
Your profile
Tag cloud
.net .net 3.5 .net 4.0 2003 access modifiers beginners book buildup c# datagridview excel f# linq microsoft reporting engine nhibernate nhprof nunit postsharp programming reflection reportviewer resharper rhino mocks structuremap unit testing vb.net vb.net. visual studio 2010 windows forms wpf
Authors
- chrissie1 (120)
- SQLDenis (17)
- Alex Ullrich (8)
- chaospandion (3)
- George Mastros (1)
- chopstik (1)
- tarwn (1)
- remou (1)
- More...
Main Categories
Search
XML FeedsGoogle Ads
Tags: excel
Excel and the divide by 100 problem
If you ever get the question from someone why excel is dividing the number by 100 for no aparent reason, Well then I have the answer ;-)
In Excel 2003 goto Tools > Options > Edit > Fixed decimal places. Chances are that that little checkbox is checked.
In excel 2007 they changed the description (automaticaly insert a decimal point) for that checkbox and ...
Luca Bolognese has released a .NET library that provides the full set of financial functions from Excel. The main goal for the library is compatibility with Excel, by providing the same functions, with the same behavior. Note though that this is not a wrapper over the Excel library; the functions have been re-implemented in managed code so that you do not need to have Excel installed to use this library.
More here including the download links: http://blogs.msdn.com/lucabol/archive/2...
LTD Social Sitings
Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.