I'm pretty sure I know the answer to this question, but I wanted to ask. I have a need to be able to use the righttoleft property with a textbox, however, what I'm having a little trouble with is how the property determines breaks when reversing characters. My data uses a number of mnemonics, so I want to treat some characters, like $'s as hard characters. So, for example:
=100 10$aTest
I would like it represented as:
tseTa$01 100=
But it gets represented as:
tseTa01$ 100=
Outside of creating a custom function (which I'm trying to avoid because then I'd have to use it both for reading and writing data -- I think) -- can the Rightoleft property be customized so I can make it work like the above.
Thanks,
--TR