In excel the value of date of bitrth changes

HITESH DEV - Mar 30, 2010 at 03:03 AM
 Dev - Apr 1, 2010 at 05:31 AM
in excel the value of date of birth changes, into numeric number. mostly that time when it paste them on any word sheet

1 reply

closeup22 Posts 8924 Registration date Friday May 15, 2009 Status Member Last seen October 7, 2010 2,108
Mar 30, 2010 at 06:36 AM
Hi there,

Please describe the issue with more information.

I use the Mail Merging & Macros to create Bio-Data's in Ms-Word of so many candidates & take their value like name. f'name , Date of Birth etc from a Excel Sheet. But i am facing the problem that as i am going to run the Macros, all the columns of excel sheet works very efficiently expect a column of Date of Birth. i used format cells & change the date of birth in format of 3/14/2001 without Asteriskk(*).

Date of Birth column has been change in Ms-word with a numeric numbers like 40322. In fact it remains same in the excel 3/14/2001.
i face this problem not every iteration. sometimes it doesn't occurs. but problem is this i can't relay to this excel sheet infact it create problem while create other Bio-Data's.

i know while calculating age it change its format but it is optional, So it should not change the text cells. So i need a to operate a function which doesn't change the text cells. plz give me appropriate answer for this problem.

Hitesh Dev