Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Example:

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.

share|improve this question

closed as too localized by Oliver Salzburg Jul 28 '12 at 16:23

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.

    
Welcome to Super User! Please take the time to improve your question. See our How to Ask and the Rubber Duck Problem Solving instructions. –  Oliver Salzburg Jul 28 '12 at 13:20

1 Answer 1

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.

share|improve this answer
    
Dear yasin txs for reply to the 1st question i could able to solve the 2nd problem by a simple method :- create 2 coloums type your reqd text , and add 2 coulums with the simple formula =b1&c1 , stike enter & drag the rows . –  Dalmon Jul 28 '12 at 14:26

Not the answer you're looking for? Browse other questions tagged or ask your own question.