This is probably a fairly easy question, but it currently has me stumped.
I have a form adding up a list of totals (in dollars, currency is set to #.## format). I was trying to extract each individual place at will. Say for example:
14.52
I want it to be able to put the 1, 4, 5, and 2 in separate cells I designate. At the moment, I'm using the Left, Right, and Len functions to do this. There is only one problem.
If every amount ends in .00 (even dollar amounts like 3.00, 4.00, 5.00, etc.) the format on the total is still set to add the .00 to the end. The problem is, when I try to use these functions on that type of number, it... doesn't "see" the .00 that is automatically added on. For example, the number 456.00. If I extract the first number on the right in that using an Excel formula (which should be 0), I get 6. Can anyone help with accounting for this? How would I go about extracting the specific numbers in specific locations?
Thanks for the help!
Bookmarks