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
Category: VBA for Microsoft Office Products
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 ...
VB6 Remove date part of DateTime
Have you ever needed to remove the time part of a date variable, or remove the date part of a date variable? I recently had a requirement to do this, and my first reaction was to use the format function because it is very flexible and quite simple to use. Unfortunately, it does't perform very well.
First, the format method for removing the time part.
Debug.Print Format(Now, "Short Date")
4/1/2009
Debug.Print Format(Now, "Short Time")
09:16
Seems simple enough to remove the date and/or time portion of a date variable, but is it the...
Someone today asked me how to copy paste the calendar in outlook to a word document. I couldn’t find the answer to that question but I found a suitable alternative instead.
The alternative is to use this dot (template) file instead. I found it on this Microsoft site..
This isn’t made for us europeans, as the Note says.
NOTE: This template solution is designed to work only with U.S....
LTD Social Sitings
Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.