[Solved] [Calc] Text to number

[grahamn]

I have the following code in a calc macro

Cell = Sheet.getCellByPosition(16,RowNo)
Cost = Cell.String
NewCost = Cost - 6
Cell = Sheet.getCellByPosition(16,RowNo)
Cell.String = NewCost

The result is a number expressed as a string, as expected, but I need a number to be able to carry out further calculations.
I have tried converting to a number using Cell.string = VAL(NewCost) and Cell.String = CSng(NewCost) but the result is still a string
Apparently I am doing something wrong but cannot find an answer after several searches.

Using Windows 10

[FJCC]

If you want the cell value, use

Code: Select all

Cost = Cell.Value

Also, there is no needto do
Cell = Sheet.getCellByPosition(16,RowNo)
twice

[grahamn]

Thanks FJCC
I'll keep this in mind for the future