ExcelReadCell unable not pulling format...

[Klexen]

When reading cell that has a money value like " $64.30" excel cuts out any 0 that is after the decimal. So you get something like, "$64.3" Also if the value is $24,223.12 I would get "$24223.12" How can I get it to keep the comma?

Any ideas?

[dantay9]

I have no idea how to change that in excel, but you could use StringSplit() to split the number by the decimal and then insert your own commas every three characters from the right side of the split string.

[Juvigy]

This has something to do with the regional settings.There you can change the options for that. basically in Excel the cell value is $24223.12 but excel shows is as $24,223.12 as it is formated as "currency"/number type.The coma is the 1000 separator in the regional settings. "How can I get it to keep the comma?"

Why would you need that?

[Masternoop]

You can set the cell property in Excel to text. This makes it keep all the formating you throw @ it. Worked for me! you do have to type the comma and the zero's but that is kinda obvious.