PC Review


Reply
Thread Tools Rate Thread

Data Form and Time Format

 
 
Jeremy Dillberg
Guest
Posts: n/a
 
      26th Nov 2003
I have formatted times in a spreadsheet with [hh]:mm:ss in
order to add past 24 hours. What I would like to know is
how come when I open a Data Form through a macro, the
information is still shown in with AM or PM or with a date
at the beginning if the total is greater than 24 hours.
Is there a way for me to format this with code. My macro
to open the data form is simple....
Worksheets("Stats").ShowDataForm

Thank you,
Jeremy
 
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
format of Form field that allows data to be copied without format =?Utf-8?B?S2VuIEdlaGxl?= Microsoft Access Forms 6 27th Oct 2006 05:59 PM
StampDate Format For Data and Time srm Microsoft Outlook Form Programming 1 8th Jun 2005 05:31 PM
format data displayed on Excel data entry form =?Utf-8?B?Qm9iLCB0b28=?= Microsoft Excel Setup 0 19th May 2005 08:26 PM
Display time on form, add current time data SandyB Microsoft Access Form Coding 1 26th Feb 2004 07:10 PM
import data time format Steve Microsoft Excel Programming 2 28th Sep 2003 03:40 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:29 AM.