Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
number to date format | Excel Discussion (Misc queries) | |||
How do you format a number into a date? | Excel Discussion (Misc queries) | |||
* next to date format in Formatcells Number tab | Excel Discussion (Misc queries) | |||
Excel: I enter date and format for date, but shows as number | Excel Discussion (Misc queries) | |||
Format date and number | Excel Programming |