The representation of a number is controlled by a Range's numberFormat property or the Number tab in the Format Cells dialog box (to be opened with right-click on a cell/range or via Ribbon-Home -> Number)
TODO
Apparently, Excel considers a number stored as text to be an error.