|
Back to home
Jump to:
Converting an SQL date in Excel
From: http://www.sitepoint.com/forums/showthread.php?t=400034&highlight=mysql+excel
Q. I've exported a MySQL database to a CSV file, but the date is a 10 digit integer, such as 1068328201. I'd like to convert this to a date format in Excel. Any ideas on how to convert it to mm/dd/yy?
A. The integer is a Unix date. It is the number of seconds from 1970. Use this formula, where A1 contains the Unix date:
=DATE(1970,1,1) + A1/86400
[22-Aug-06]
Extracting images from Word
If you have screen shots in a Word document, you can't simply copy and paste them into somewhere else to save them. If you try, you'll see that the new image has been resized and the colors have been modified. This is because Word uses the clipboard in a non-standard way.
The easiest way is to use Microsoft Photo Editor:
- Copy the image in the Word document.
- Paste the image into Microsoft Photo Editor.
- Save as a PNG or copy/paste into another graphics program
Photo Editor is part of Office, but was apparently removed from Office 2003 and later. More information on the Office forum.
Here's an article describing how to install Photo Editor if you have Office 2003 installed.
[22-Aug-06]
|
