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!

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!

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

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!