Search : in
By :

Date to number format using macro

Last answer on Feb 10, 2009 9:40:45 am GMT moses, on Aug 20, 2008 1:52:41 pm BST 
 Report this message to moderators

Hello,
in a macro i have captured the date into a variable. i need to convert that date to a number format to used for further processing.
thanks,

Configuration: Windows XP
Firefox 3.0.1

Best answers for « date to number format using macro » in :
Get back data on formatted hdd Show
Changin format of date in excel Show
Databases - Using forms Show Using forms In order to use databases, the user must be provided with an interface that allows him or her to view data based on certain criteria. There is a tool for this: forms. A form is an interface with components for displaying, entering, or...
How to read a file .RAR? ShowWinrar superNZB How to read a file .RAR? RAR is a data compression format developed by Roshal. This file format can be used for data recovery and file spanning. Winrar Winrar is the perfect tool for opening and decompressing .RAR...
Verifying date format in PHP ShowVerifying date format in PHP There are several ways to check the format of a date in PHP; the simplest method is to make use regular expressions. To confirm a date format DD/MM/YYYY, where the days and/or month can be given as...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
S/PDIF format ShowS/PDIF format The S/PDIF standard ("Sony/Philips Digital Interface", or SPDIF for short) is a digital audio data transfer format. It is an international standard known as "IEC-958 type II", which defines both hardware specifications (physical...
Database administrator ShowDatabase administrator A database administrator (or DBA for short) is in charge of maintaining and operating the databases which form a company's information system. Skills Given the critical nature of the data he/she is in charge of, the...
Ogg Vorbis ShowIntroduction to the Ogg Vorbis format Ogg Vorbis is an audio data compression format developed by Xiph.org. As with the MP3 format, it's a form of compression which reduces some of the audio data, called "lossy compression". This means eliminating...
Ask your question Reply

1

use4, on Sep 5, 2008 9:09:47 am BST

'for date to display as text

cell.NumberFormat = "@" 'Text

'to change date style

cell.NumberFormat = "dd/mm/yyyy" 'or whatever style

   
Reply to use4

2

 suni, on Feb 10, 2009 9:40:45 am GMT
  • +6

Cell.NumberFormat = "dd/mm/yyyy"

where to write this excel sheet?

   
Reply to suni
Ask your question Reply
They need your help