My request should be fairly simple: I need to know where the content of a
cell (not format or anything else) is stored for being used in VBA. If I have
multiple cells selected, I want to know how to reference the content of each
one, and later apply some changes to each one in the selection.

Below is the practical application of what I'm trying to implement:

I'm creating a macro for some accountants and I need to get them to format
their tables correctly. If a cell contains a negative number, it appears in
brackets. The problem is, the comas from each cell won't align because
positive numbers don't use brackets, so the position of the comas on a colum
will vary.

All I want is a simple macro that, with multiple rows selected, after a
certain key combination, will add a blank space to the end of a positive
number and leave negative numbers untouched. I've been looking over it and
suppose it's down to using If clauses, so if the last char of the cell isn't
a ")", it will append a blank space (or empty char) to the end of the cell's
contents.

Thanks