Posted to microsoft.public.excel.misc

Posts: n/a

excel converts date/time value to exponential value

Hi,

I have a CSV file that was exported by a database. However, when I
import this csv to excel, I see that the date/time value seems to have
changed to an exponential value. For example,
20060602084140 is converted to 2.00606E+13.

1. Why is this happening?
2. Can I convert 20060602084140 to a regular date / time value?

Thanks in advance,
-V

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
unhide menu bar in excel - just disappeared	Sean	Setting up and Configuration of Excel	12	April 4th 23 10:19 AM
Open Excel 2003 from Windows Explorer	pmpjr	Excel Discussion (Misc queries)	9	September 11th 06 03:58 PM
Why if I type in 51570.6213 Excel converts it to 51570.5213999999	chd	Excel Discussion (Misc queries)	5	April 9th 06 02:51 AM
cell format for date/time in same cell excel 2003	Sandy	Excel Worksheet Functions	1	January 18th 06 03:46 AM
Using Excel converts number to english text	Lionel Lim (Malaysia)	Excel Worksheet Functions	1	April 22nd 05 10:16 PM

All times are GMT +1. The time now is 02:58 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us