| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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: -- garyww ------------------------------------------------------------------------ garyww's Profile: http://www.excelforum.com/member.php...o&userid=35818 View this thread: http://www.excelforum.com/showthread...hreadid=555948 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
predefine english word on the cell
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: -- garyww ------------------------------------------------------------------------ garyww's Profile: http://www.excelforum.com/member.php...o&userid=35818 View this thread: http://www.excelforum.com/showthread...hreadid=555948 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Excel 2003 Word Wrap Problem within cell | Excel Discussion (Misc queries) | |||
| in an excel macro can you import data from word into a cell? | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| have cell display the word balance when a equals the same amount a | Excel Discussion (Misc queries) | |||
Hybrid Mode
