View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
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!