I am using freespire office (xls) to write values to specific cells in a spreadsheet.
I the spreadsheet that is opened has the cells formatted to "Text" but when I set the value
- Code: Select all
Worksheet.Range("C22").value = "75.00"
it converts the cell to a number format and strips the .00
if I set the format to "0.00"
- Code: Select all
WS.Range[Cell].NumberFormat = "0.00";
it shows the formatting however the value in the cell is still in the stripped state.
The only way to seem to get the cell value to retain the .00 is to set specifically to the Text formatting...
but I can't seem to find a way to do that with freespire office, and I can't seem to prevent the setting of the cell value from changing the format.
I have attached a screen shot that hopefully conveys the issue.