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.

For example, if the number is 123456, I want it to become RNE123456.

share|improve this question
    
Do you want it to only display as RNE123456 or become the text RNE123456? Becoming text will mean you will not be able to carry out mathematical operations on it, while changing only the display allows you to carry out mathematical operations on it. –  Jerry Apr 14 at 17:29

3 Answers 3

Is this what you need?

  • Select required cells (whichever cells you want automatically prefixed) and right click for the context menu, then select Format Cells (or press + 1)
  • Select Custom from Category list.
  • Type in:

"RNE"General

If you want to change the prefix obviously you can remove RNE and input any prefix string.

Press OK and return to the spreadsheet. It should automatically prefix the rows.

Image of Format Cells dialog

Enlarging column should fix 'E' errors:

share|improve this answer
    
I did the same , but the general numbers r showing as "RNE1.2012E+11 " . how do I change to numbers with the text RNE120.....245 –  Dalmon Jul 28 '12 at 13:00
    
@Dalmon All you need to do is enlarge the column or row and it will rectify instantly. Thanks! –  ysoliman Jul 28 '12 at 13:01
    
No dear i have tried the same before mailing & even now , remain same . RNE1.2012E+11 , another problem I noticed is the same no is getting copied in entire coloum . –  Dalmon Jul 28 '12 at 13:30
    
@Dalmon I think it works in rows but if you want the actual column to be prefixed i think you might need another solution. Sorry for the inconvenience! –  ysoliman Jul 28 '12 at 13:31

Why do not use just the Replace (Ctrl+H) feature?

enter image description here

share|improve this answer

Use Custom format _ "RNE" @_.

This works also on numbers. You can also type this format under conditional formatting to apply to more creative answers.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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