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
>
>
>