Hi,
I'm trying to format cell to number format with no decimal.

The .numberformat "0" works for values that are already set as number, but the values set as text(the cell is text and value a number) do not convert to number with no decimal.

thanks