Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Format Problem - Date Overrides Format | Excel Discussion (Misc queries) | |||
date format problem from opening dbf file in excel 2007 | Excel Discussion (Misc queries) | |||
date format problem?? | Excel Discussion (Misc queries) | |||
Excel 2007 Date Format Problem | Excel Discussion (Misc queries) | |||
Excel 2003, problem with UK date format, using OLE | Excel Programming |