Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 '14 at 17:29

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:


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! – AruAkise 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! – AruAkise 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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .