Ray, thanks for your help. I actually want the number itself to be
converted to a whole number ie not just a formatted number ie the actual
number itself won't have any dec decimals.

Thanks,

Roger


"Ray A" <RayA@discussions.microsoft.com> wrote in message
news:380AEC7B-D3A4-4D56-BD8C-EBF75D90E7D1@microsoft.com...
> one way;
> copy the date and then paste special >values
> HTH
>
> "Roger B." wrote:
>
>> I have a date in a cell which is in Date format and I would like to
>> convert
>> this to a whole number format (ie no decimals in the result) using a
>> macro.
>>
>>
>>
>> Any suggestions would be greatly appreciated.
>>
>>
>>
>> Roger
>>
>>
>>