LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 62
Default Formatting and sorting cells with VBA

will repost this as new question...

"deko" wrote in message
m...
By the way, the reason for the text field (rather than date) is because

the
chart that is created from this data gets it X-axis labels from the column
with the date values - and only the date (10/12/2004) shows in the X-axis
rather than the date and time (10/12/2004 13:23) when the columns is
formatted as date. With a string, I get the time as well as the date.




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Sorting Cells with Conditional Formatting Edie Excel Discussion (Misc queries) 2 June 3rd 08 02:21 AM
Date Formatting & Sorting Irfan Khan[_2_] Excel Discussion (Misc queries) 2 April 4th 08 06:00 PM
Sorting with Formatting Patricia Excel Discussion (Misc queries) 4 December 8th 07 12:59 AM
Formatting Date for Sorting KP Excel Discussion (Misc queries) 2 September 18th 06 05:10 PM
Sorting ListBox results or transposing ListBox values to other cells for sorting Rob[_8_] Excel Programming 1 July 9th 03 04:35 AM


All times are GMT +1. The time now is 10:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"