Excel cells

[acidman]

Hi there...

How do you write data to 2 excel cells or extended the length of a cell Because when I write a numerical string Longer Than 12 characters it makes it some weird formula. any help?

[water]

Weird formula? You are talking about floating point numbers. Either change the format of the cells so they are displayed as integers or enter them as text.

Text means

_ExcelWriteCell($oExcel, "'1234567890123456", 1, 1)

[acidman]

yea see I'm busy developing software so the code is a bit too huge to display as a spoiler. if I get the number from an Input box "9012494654654654" and write it tp an xls document but it gives me a weird formula when I view The xls file it doesnt display the number.

[water]

Try something like this:

$sInput = InputBox(....)
_ExcelWriteCell($oExcel, "'" & $sInput, 1, 1)

[acidman]

Thanks A lot my man, I appreciate it dearly!

[water]

Glad to be of service

N.B. Now the cells content is handled as a string by Excel. So for later calculations you have to convert it to a number or instead of writing the number as text to Excel the formatting of the cell has to be changed.