Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Date format problem in Excel

Hi,
I developed an application in PB that exports data to a csv
file. It's working fine, but one of the field which is of type timestamp
has data like "01/26/2005 11:26:44 AM", but it's displaynig there as
#############. And i move mouse over that column it's showing correct
value in tooltip box, when i clicked on the column then it's converting
to original data value.

My problem is without doing anything, how can see the orginal data apart
from ##########.?

Thanks in advance.

Regards
Rama


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 400
Default Date format problem in Excel

Click on the column holding the timestamp data, then Format + Column +
Autofit Selection.

"Rama Bangaru" wrote:

Hi,
I developed an application in PB that exports data to a csv
file. It's working fine, but one of the field which is of type timestamp
has data like "01/26/2005 11:26:44 AM", but it's displaynig there as
#############. And i move mouse over that column it's showing correct
value in tooltip box, when i clicked on the column then it's converting
to original data value.

My problem is without doing anything, how can see the orginal data apart
from ##########.?

Thanks in advance.

Regards
Rama


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,651
Default Date format problem in Excel

On Wed, 09 Mar 2005 00:54:53 -0800, Rama Bangaru
wrote:

Hi,
I developed an application in PB that exports data to a csv
file. It's working fine, but one of the field which is of type timestamp
has data like "01/26/2005 11:26:44 AM", but it's displaynig there as
#############. And i move mouse over that column it's showing correct
value in tooltip box, when i clicked on the column then it's converting
to original data value.

My problem is without doing anything, how can see the orginal data apart
from ##########.?

Thanks in advance.

Regards
Rama


If your column is too narrow, you will see #########. Perhaps you just need to
widen the column?


--ron
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default Date format problem in Excel

Widen the column.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Rama Bangaru" wrote in message
...
Hi,
I developed an application in PB that exports data to a csv
file. It's working fine, but one of the field which is of type timestamp
has data like "01/26/2005 11:26:44 AM", but it's displaynig there as
#############. And i move mouse over that column it's showing correct
value in tooltip box, when i clicked on the column then it's converting
to original data value.

My problem is without doing anything, how can see the orginal data apart
from ##########.?

Thanks in advance.

Regards
Rama


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Reply
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
Excel Format Problem - Date Overrides Format Mary Excel Discussion (Misc queries) 5 February 10th 10 05:49 AM
date format problem from opening dbf file in excel 2007 pol Excel Discussion (Misc queries) 5 December 1st 08 11:42 AM
date format problem?? Steve[_9_] Excel Discussion (Misc queries) 10 December 27th 07 11:23 PM
Excel 2007 Date Format Problem terry Excel Discussion (Misc queries) 0 November 25th 06 06:16 AM
Excel 2003, problem with UK date format, using OLE Bill Dallas Excel Programming 1 August 18th 04 09:06 AM


All times are GMT +1. The time now is 04:14 AM.

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

About Us

"It's about Microsoft Excel"