PC Review


Reply
Thread Tools Rate Thread

CSV, Milliseconds default formatting of mm:ss.0

 
 
Christopher Pankhurst
Guest
Posts: n/a
 
      3rd Aug 2006
When I generate some CSV files I need to include milliseconds. When anyone
opens the file in Excel (in my case part of Office 2003, SP2) the datetimes
appear with a default formatting of mm:ss.0. This is frustrating and appears
unprofessional on my part when clients open the file. They assume I have
made some sort of mistake.

I have already thought of generating using
=DATE(blah)+TIME(blah)+millis/(24*60*60*1000) but I don't like the idea.

How can I change the default format so that it would be something more
sensible and my clients and I could avoid the drudgery of clicking on the
column header(s) and manually formatting?

I have googled, I have searched my registry and regional settings. Nothing
that I could find helped at all.

Please see the attachment for a demonstration.

Thanks,
Chris Pankhurst




 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
hh:mm:ss AND Milliseconds? Lainey25 Microsoft Excel Misc 5 6th May 2008 05:32 PM
milliseconds?? =?Utf-8?B?c2d5YW4x?= Microsoft Access Reports 1 27th Sep 2007 12:16 AM
Re: Formatting Cells to use Min:Seconds.Milliseconds Frank Kabel Microsoft Excel Misc 0 13th Jul 2004 06:57 PM
Milliseconds In VB ccdubs Microsoft Excel Programming 1 26th Feb 2004 11:20 PM
milliseconds PCH Microsoft Dot NET Compact Framework 10 10th Oct 2003 11:23 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:13 AM.