View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
AA2e72E AA2e72E is offline
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!