Flux rss
Search : in
By : Relevance Date Username
Statut : Not resolved

Date to number format using macro

moses, on Wednesday 20 August 2008 à 13:52:41
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
Reply to moses  Report this message to moderators Go to last message

1


  • This message seems useful, vote!
  • Report this message to moderators
 use4, on Friday 5 September 2008 à 09:09:47
'for date to display as text

cell.NumberFormat = "@" 'Text

'to change date style

cell.NumberFormat = "dd/mm/yyyy" 'or whatever style
   
Reply to use4
Ask your question Reply

Résultats pour date to number format using macro

How data is formatted Hello, Which layer defines how data is formatted, presented, encoded, and converted for use on the network ? en.kioskea.net/forum/affich-2744-how-data-is-formatted
Spreadsheets - Worksheets Spreadsheets display data and formulas in a table form (lines and columns) called a worksheet. A worksheet is made of lines (numbered with numbers) and of columns (numbered with letters). The intersection of a line and a column is called a cell. A... en.kioskea.net/tableur/tabfeuille.php3
MP3 MP3 ("MPEG Audio layer 3") is a lossy audio data compression format, developed by the International Organization for Standardization (ISO). This format is used to compress normal audio formats (WAV or CD audio) at a rate of 1:12. As mp3 files, the... en.kioskea.net/audio/mp3.php3

Résultats pour date to number format using macro

How to read a file .RAR?Winrar 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... en.kioskea.net/faq/sujet-397-how-to-read-a-file-rar
Restoring your Nokia phoneRestoring your Nokia phone Normal Reset Deep Reset How to proceed There are two methods allowing you to reset your phone to a more unwavering state. Normal Reset Using the *#7780# sequence. It will restore ini files from ROM... en.kioskea.net/faq/sujet-421-restoring-your-nokia-phone
Formatting Your Hard DriveFormatting Your Hard Drive Formatting and installing your Hard drive using the installation CD ] A hard disk drive is a non-volatile device mainly for data storage. Usually faster than any other storage device, this essential... en.kioskea.net/faq/sujet-194-formatting-your-hard-drive
1 2 3 Next

Résultats pour date to number format using macro

Get back data on formatted hddHey there, Just wanted to know if its possible to get back the data on a formatted hard drive and if yes how can it be done ? en.kioskea.net/forum/affich-28522-get-back-data-on-formatted-hdd
Excel Number FormatsHello, I am trying to figure out a formula so that I can have one numer showing, but for it to have a different value. Example: 2^7 as the value in Cell A1 1 showing in Cell A1 I am trying to create a spreadsheet that will calculate a subnet value up... en.kioskea.net/forum/affich-30641-excel-number-formats
Date format in excel.Hello again, Is there a way to make excel read fields left padded with a 0. For example I have a program that only reads date format like this yymmdd, so when I open the csv file in excel it reads 080725 as 80725 instead. Then when I save any changes... en.kioskea.net/forum/affich-16756-date-format-in-excel
1 2 3 Next

Résultats pour date to number format using macro

Download EASEUS Partition ManagerEaseUs Partition manager Free, is software par excellence to be had on the system. EaseUs Partition Manager partition easily and without error your disk hard in size which you chose: Main characteristics of EaseUs Partition Free: Material support... en.kioskea.net/telecharger/telecharger-380-easeus-partition-manager
1 2 3 Next

Résultats pour date to number format using macro

WiMAX promises to transform wireless Internet worldVisitors walk past the WiMAX stand at the 3GSM congress in Barcelona, in February 2007. As US technology giants including Google place a multi-billion dollar bet on WiMAX, backers of the wireless data-streaming format say it will radically change... en.kioskea.net/actualites/wimax-promises-to-transform-wireless-internet-world-10353-actualite.php3
WiMAX promises to transform wireless Internet worldVisitors walk past the WiMAX stand at the 3GSM congress in Barcelona, in February 2007. As US technology giants including Google place a multi-billion dollar bet on WiMAX, backers of the wireless data-streaming format say it will radically change... en.kioskea.net/actualites/wimax-promises-to-transform-wireless-internet-world-10354-actualite.php3
1 2 3 Next

Résultats pour date to number format using macro

Audio - S/PDIF 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 connection... en.kioskea.net/audio/spdif-s-pdif.php3
AAC (m4a) AAC (Audio Advanced Coding) is an audio data compression format developed by the Fraunhofer Institute in cooperation with AT, Nokia, Sony and Dolby. As with the MP3 format, it's a form of compression which removes some of the audio data, called... en.kioskea.net/audio/aac-m4a.php3
IT professions - ADatabase administrator A database administrator (or DBA for short) is in charge of maintaining and operating the databases which form a company's information system. Given the critical nature of the data he/she is in charge of, the database administrator must be well... en.kioskea.net/metiers-informatique/administrateur-bases-donnees.php3
1 2 3 Next