Has anyone found out how to formate an Excel cell without writing a value in it?
I want to create a column where suppliers shall enter their prices. The column shall be empty from the beginning, but the cells should be currency formatted so two decimals show up when sombody enter a price.
Send WriteNum of hoSheet iRow iCol '' hoAmountFormat - gives zeros in the cells.
Set DefaultColumnFormat of hoLagerSheet iRow iCol to hoMoneyFormat - doesn't seem to have any exffect
There ought at least to be a way to delete the value in a cell. When working normally with Excel, you just press Delete.
Bengt