The Photo Picture with a Billion Views
The default windows XP back drop image is the most viewed photo in the World. The photo was taken by National Geographic Magazine Photographer, Chuck O’Rear, who was paid a huge undisclosed amount by Microsoft. The photo was taken as Chuck drove on Highway 121 in California’s Sonoma Valley when the landscape caught his eye. Chuck immediately parked his car and took out his camera and took a snap through the fence. The site is a vineyard, but at the time, the area had been devastated by the Phylloxera bug that lead to all the vines being removed, hence revealing green rolling pastures that nearly all of us have come to recognise as the bliss background image that braces PCs all around the World.
Categories: Horticulture, Interesting News Tags: background, background image, bliss, braces, default windows, fence, high, landscape, magazine photographer, microsoft, national geographic, national geographic magazine, os, photo, snap, sonoma valley, vines, windows xp
Microsoft Excel Number of Days in a Month
If, for example, you want Microsoft Excel to calculate the number of days in a date, then you can use the following formula:
=DAY(DATE(YEAR(B2),MONTH(B2)+1,1)-1)
Where B2 is the cell with the date you want to calculate total days in the month for.
Here is a snap shot of what I mean:
Categories: Microsoft Excel, Software Tags: calculate, microsoft, Microsoft Excel, number
Microsoft Excel: Removing Hyperlinks From Cells
Removing hyperlinks from cells can be tricky in that you can trigger them when you don’t intend to. So what is the best way to remove them?
- Select a cell not to far from the cell with a hyperlink
- Use your arrow keys to navigate to it
- press CTRL+X, a shortcut to cut the contents of the active cell
- from the Edit menu to find Paste Special
- a dialog box should appear, here select Unformatted Text
Job done!
Categories: Computers, Microsoft Excel, Software Tags: arrow keys, cells, dialog box, hyperlinks, job, microsoft, Microsoft Excel
