numerical prefix?

psalm60nine

New Member
Joined
Nov 28, 2005
Messages
4
is it possible to format a cell so that if any letter is entered, it will display with a numerical prefix?

I want the number "65" to appear before an entered letter.
example:
enter "M" . . . . display "65M"

anyone got anything?
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
Welcome to MrExcel - you can Custom format the cell - Format/Cells/Custom - with

"M"0
 

psalm60nine

New Member
Joined
Nov 28, 2005
Messages
4
I know how to do that, but what I'm trying to do is the opposite of what you explained.

I'll be entering a column of different letters, but I want the number "65" before all the different letters.

ex:
65M
65F
65T
65X

I'm assuming if it is possible, I'll have to format the cell, and enter a custom formula . . . I'm just not sure what to enter there though.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,057
Office Version
  1. 365
Platform
  1. Windows
Do you mean that if A was entered then 65A would be displayed?

If so I don't think this is possible using just a format.

The only way I can think of would be using VBA.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,386
Messages
5,571,829
Members
412,421
Latest member
grace_abar
Top