Klexen Posted May 7, 2009 Share Posted May 7, 2009 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? Link to comment Share on other sites More sharing options...
dantay9 Posted May 7, 2009 Share Posted May 7, 2009 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. Link to comment Share on other sites More sharing options...
Juvigy Posted May 8, 2009 Share Posted May 8, 2009 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? Link to comment Share on other sites More sharing options...
Masternoop Posted May 20, 2009 Share Posted May 20, 2009 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now