Your best bet is to prepend each values with a single quote '

'0000123456

>
>I am using Excel automation to populate some cells with data. How can I tell Excel to format a cell as character before sending through the data?