Date to Number format
 

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

Date to Number format
 

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

Date to Number format
 

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" wrote in message
...
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

Date to Number format
 

format as general not as number

the macro instruction would be

Range("A12").Select
Selection.NumberFormat = "General

--
bill

-----------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...info&userid=82
View this thread: http://www.excelforum.com/showthread.php?threadid=47889