#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default Error in date field

Hi
The problem i am facing is , I am populating data from database to
Excel , while downloading the data to excel the column in the excel which
is date filed values are printing like '##########' in the excel sheet. I
have checked the regional settings and format cells options but no
resolvment. please help...

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 63
Default Error in date field

Have you checked that your column is wide enough?

Andrea Jones

"satya" wrote:

Hi
The problem i am facing is , I am populating data from database to
Excel , while downloading the data to excel the column in the excel which
is date filed values are printing like '##########' in the excel sheet. I
have checked the regional settings and format cells options but no
resolvment. please help...

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linked date field in worksheet defaults a blank field as 1/0/1900 AmnNkD Excel Worksheet Functions 2 September 12th 06 05:42 PM
parsing a date field carriex3 Excel Discussion (Misc queries) 2 August 1st 06 09:30 PM
How do I format date field in footer? Terry Sharman New Users to Excel 5 April 12th 06 08:08 PM
Date & Time Field Diane Walker Excel Discussion (Misc queries) 2 January 10th 06 03:30 PM
Excel date field link to Word Earl Excel Discussion (Misc queries) 1 July 13th 05 11:20 PM


All times are GMT +1. The time now is 01:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"