Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 24
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 24
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
number to date format womit Excel Discussion (Misc queries) 3 July 2nd 08 03:27 PM
How do you format a number into a date? Kim Excel Discussion (Misc queries) 6 September 12th 06 03:30 PM
* next to date format in Formatcells Number tab Marco18+ Excel Discussion (Misc queries) 6 April 5th 06 08:40 PM
Excel: I enter date and format for date, but shows as number spohar Excel Discussion (Misc queries) 2 March 10th 06 08:40 PM
Format date and number Cindy Excel Programming 3 May 14th 04 10:06 PM


All times are GMT +1. The time now is 06:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"