enclose your calculation inside a call to TextFormatRemove:
TextFormatRemove ( put your current calculation here )
Go to each of the text fields and remove the data level formatting. This can be done with TextFormatRemove and a Replace Field Contents action. Now add an auto-enter calc: TextFormatRemove(Self) in order to keep future data edits/pastes from formatting the contents of the field.
Thanks so much for the help! I am a novice at this but have built a very complicated database over the past 3-4 years...maybe I'm paying now for some poor programming in the past, but these forums have been immensely helpful... :)