I've been away for a few days, sorry about not answering sooner.
The other data will start at the decimal point and be an exact number of characters which will be removed prior to converting back to a date.
Without wishing to teach granny to suck eggs; VB /VBA /or VBscript will output this (a question mark is shorthand for print to screen):-
?dbl(now()) - means print to screen the date and time at exactly now and format as a double
this will output 40998.4875347222
?cdate(40998.4875347222) - means print to screen and format the number as general date/time
this will output '30/03/12 11:42:03'
The data I would like to store is the date conversion from the double.
Hope this helps.