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

"garyww" wrote:

>
> 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: garywwww3@hotmail.com
>
>
> --
> garyww
> ------------------------------------------------------------------------
> garyww's Profile: http://www.excelforum.com/member.php...o&userid=35818
> View this thread: http://www.excelforum.com/showthread...hreadid=555948
>
>