Date format problem in Excel

[Rama Bangaru]

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

 

[Guest]

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

 

[Ron Rosenfeld]

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

 

[Bob Phillips]

Widen the column.

--

HTH

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