Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Brandos

    Alias of a created date

    I have averaged temperatures for days over the last 4 years (ie average temperatures for 6th June). I have done this by using: <Day number>=DayNumberOfYear(<Date Rolling(historic temp)>) <New Date>=RelativeDate('1/1/01' ,<Day number>) I now want to show these results on a graph along with...
  2. Brandos

    Format Month Number

    I have a database with a Time dimension that has an attribute of month number in the year (eg &quot;3&quot; for all dates in March). I want to display this as a date, not a number (ie as &quot;Mar&quot;). This sounds really easy I know, but I can't work out how to do it. Thanks in advance for...
  3. Brandos

    Conditional Formatting - identify formulas vs numbers

    Thanks a lot - that worked a wonder!
  4. Brandos

    Conditional Formatting - identify formulas vs numbers

    In Excel, I want to apply Conditional Formatting to a range of cells. I want to distinguish between cells that contain a formula, and those that have been overtyped with a number. Any ideas, anyone? Cheers..

Part and Inventory Search

Back
Top