Originally it was (as text format ) 23456789. After adding text it read as RNE1.2012E+11 but if I format using format cells only numbers are restored.
This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.
This method only stores the number, as the 'RNE' is the Custom formatting and the number is just a standard numeric value. It only works for prefixed numeric values, not text or other formatted cell values.
The added prefix text will only stay if the Custom formatting is enabled in Format Cells.