Format Cell as Date *3/14/2001

[SkysLastChance]

Is there an easy way to format a cell to date or currency? I found some old threads that were not much help. 

I have looked at the wiki but I only see how to format as a number

I assume there is not a way like I did for making the text bold. 

Any suggest or help would be appreciated. 

 

 

I am able to get the format changed to text using

$oExcel.Activesheet.range("A1:L1").NumberFormat = "@"

 

expandcollapse popup

#include <Excel.au3>

Global $sBox

Func InputHowMany()

    While 1
        $sBox = Number(InputBox("How many?", "How many?"))
        If $sBox = 0 Then
               $iMsg = MsgBox(1, 'Oops', 'Please enter a valid number')
            If $iMsg = 2 Then Exit
        Else
            Return $sBox - 1
        EndIf
    WEnd
 EndFunc

InputHowMany()
$oExcel = _Excel_Open()
$oExcel = _Excel_BookNew($oExcel)

Local $t = 2
Local $w = 1
Local $c = 301

$oExcel.Activesheet.range("A1:L1").font.bold = True


Do
   _Excel_RangeWrite($oExcel,Default, "Status", "A1")
   _Excel_RangeWrite($oExcel,Default, "Last Name", "B1")
   _Excel_RangeWrite($oExcel,Default, "Last Name", "C1")
   _Excel_RangeWrite($oExcel,Default, "SSN", "D1")
   _Excel_RangeWrite($oExcel,Default, "DOB", "E1")
   _Excel_RangeWrite($oExcel,Default, "Email", "F1")
   _Excel_RangeWrite($oExcel,Default, "Mailing Address", "G1")
   _Excel_RangeWrite($oExcel,Default, "City", "H1")
   _Excel_RangeWrite($oExcel,Default, "State", "I1")
   _Excel_RangeWrite($oExcel,Default, "Zip Code", "J1")
   _Excel_RangeWrite($oExcel,Default, "Gender", "K1")
   _Excel_RangeWrite($oExcel,Default, "Phone", "L1")

   _Excel_RangeWrite($oExcel,Default, '=B' & $c, "B" & $t)
   _Excel_RangeWrite($oExcel,Default, '=C' & $c, "C" & $t)
   _Excel_RangeWrite($oExcel,Default, '=D' & $c, "D" & $t)
   _Excel_RangeWrite($oExcel,Default, '=E' & $c, "E" & $t)
   _Excel_RangeWrite($oExcel,Default, '=F' & $c, "F" & $t)
   _Excel_RangeWrite($oExcel,Default, '=G' & $c, "G" & $t)
   _Excel_RangeWrite($oExcel,Default, '=H' & $c, "H" & $t)
   _Excel_RangeWrite($oExcel,Default, '=I' & $c, "I" & $t)
   _Excel_RangeWrite($oExcel,Default, '=J' & $c, "J" & $t)
   _Excel_RangeWrite($oExcel,Default, '=K' & $c, "K" & $t)
   _Excel_RangeWrite($oExcel,Default, '=L' & $c, "L" & $t)

      $c = $c + 1
      $t = $t + 1
      $w = $w + 1

Until $w > $sBox

 

 

 

Edited May 26, 2017 by SkysLastChance

[anthonyjr2]

You should be able to do

$oExcel.Activesheet.range("A1:L1").NumberFormat = "yyyy-mm-dd"

For that specific date format.

[water]

The link I posted in the wiki for numbers contains examples for date format as well: http://peltiertech.com/Excel/NumberFormats.html

Edited May 26, 2017 by water