When I enter only a month and day for a date, Excel displays it using dd-mmm format. 2-18 becomes 18-Feb. Excel "knows. to add the year to the value. If I enter all three components, it gets displayed as 2/18/05. (which is what I want).
Is there anyway to make the mm/dd/yyyy the default...
When I try to acces internet options through IE I'm told that I don't have the correct access blah, blah contact Administrator. (I have administrator rights)
I can get to the options by going through control panels however. Once I'm there, I cannot change the home page. It's greyed out. I'm...
Is there any way to keep the Office help screen from "sharing" the screen?
On my old computer (Win95), when I would start the help file, the Help screen would open maximized and the application would stay the same size (maximized). With the new computer (WinXP), once I start the...
I've created (copied from thread68-603752) a UDF and want to make it more "universal".
When I create it in a module for a workbook, I can reference it using:
=ShowFormula(G13)
If I put it in a module in the personal.xls I have to reference it using...
What causes the "Read past end of TSLV record" error? More importantly, can anything be done about it? The error occured on a report in which the only change was the addition of a formula field. (If it can be at all helpful, the formula added can be seen here -> thread149-304415 )...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.