ms excel predefine english word on the cell

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

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.

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=555949

--

Dave Peterson