Excel cell format!

[golfinhu]

I have a problem with Excel, can someone help me?

In the first code, why the zero is not written in the cell?

#include <Excel.au3>
Local $oExcel = _ExcelBookNew() ;Create new book, make it visible
For $i = 1 To 10 ;Loop
    _ExcelWriteCell($oExcel, "0" & Random(1,99, 1), $i, 1)
    _ExcelWriteCell($oExcel, "0" & Random(1,99, 1), $i, 2)
Next
Sleep(3000)
_ExcelBookClose($oExcel) ; And finally we close out

and if i try read a cell that is initiated by zero, excel do not bring that zero too! =/

I just need to know how to get and write zeros in excel! (in first position)

Thanks a lot!

Edited February 9, 2012 by golfinhu

[lorenkinzel]

First code: Excel doesn't like leading zeros. If you open a sheet & type "048" you get "48".

If you change _ExcelWriteCell($oExcel, "0" & Random(1,99, 1), $i, 1) to

_ExcelWriteCell($oExcel, ".0" & Random(1,99, 1), $i, 1) (note the decimal before the zero)

then it writes the zero.

This answers the "why" question but unfortunately gives no "how".

Edit: _ExcelWriteCell($oExcel, "'0" & Random(1,99, 1), $i, 1) using an apostrophe before the zero

This gets you a zero without the unwanted decimal.

http://www.techrepublic.com/blog/msoffice/entering-leading-zeroes-in-excel/2360

Edited February 9, 2012 by lorenkinzel

[BrewManNH]

Store it as text instead of as a number use "'0", put a single quote in front of the number that starts with 0 and it will be stored in the cell as text.

[golfinhu]

Thanks a lot lorenkinzel and BrewManNH

It works perfectly!

now i only need know how to i get it from excel ;p