ms excel predefine english word on the cell

  • Thread starter Thread starter garyww
  • Start date Start date
G

garyww

how to predefine an english word ie. "S" on the cell. So, user each
time
just type in ie. 1243 and the cell will return S1243. Then the user no
need to type so many times of "S" in front of 1243. If the user ie.
type it 1244, then it returns "S1244" automatically. Any hints and
steps and procedure as well.
thanks
gary
email: (e-mail address removed)
 
If you're always typing numbers, you can use a custom number format of:

\S0000

Format|cells|number tab|custom category

This won't change the value of the cell, but it will display that leading S.

If you type anything to make the value non-numeric, then this format won't
apply.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

predefine english word on the cell 1
Last Modified By in a cell by user 3
Excel: Replace strings with a Matrix formula 6
Predefined autotext won't auto complete 4
Filter out rows based on the value of a cell 4
Word Using the 'IF' Formula in MS Word 2010 0
The word "zero" appeared in a cell. 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top