predefine english word on the cell

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: [email protected]
 
T

Toppers

For your example CUSTOM format as "S"# (with the double quotes).

If you want "S" to be variable, then (I think!) you will have to use VBA.

HTH
 
Top