| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Character and number in a cell - Can you help?
I am trying to create a cell that can accommondate characters and
numbers. The first 12 spaces in a cell should reserve for character, and the 13rd onward will be numbers. For example, if I enter ABC123, it should written in the cell as 'ABC 123'. Any idea? Please help. Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Character and number in a cell - Can you help?
Hi
it would be better if you use two separate cells for this "Woo" wrote: I am trying to create a cell that can accommondate characters and numbers. The first 12 spaces in a cell should reserve for character, and the 13rd onward will be numbers. For example, if I enter ABC123, it should written in the cell as 'ABC 123'. Any idea? Please help. Thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Character and number in a cell - Can you help?
You can only format a cell as number or text, so you must format as Tex in this case. If you need to use the numbers in a calculation you wil have to convert the text back to numbers in your formula or use anothe column for the numbers perhaps hidden). -- Brian ----------------------------------------------------------------------- BrianB's Profile: http://www.excelforum.com/member.php...tinfo&userid=5 View this thread: http://www.excelforum.com/showthread.php?threadid=27829 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Character and number in a cell - Can you help?
AFAIK, it's not possible to do this with formatting.
On 15 Nov 2004 06:44:35 -0800, (Woo) wrote: I am trying to create a cell that can accommondate characters and numbers. The first 12 spaces in a cell should reserve for character, and the 13rd onward will be numbers. For example, if I enter ABC123, it should written in the cell as 'ABC 123'. Any idea? Please help. Thanks. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Character and number in a cell - Can you help?
You have to write a macro to make it work -- anilsolipura ----------------------------------------------------------------------- anilsolipuram's Profile: http://www.excelforum.com/member.php...fo&userid=1627 View this thread: http://www.excelforum.com/showthread.php?threadid=27829 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add number from a cell that contains a specific character | Excel Worksheet Functions | |||
| Limit number of character per cell to 26 in excel | Excel Worksheet Functions | |||
| Number of character in one cell. | Excel Worksheet Functions | |||
| number of character occurences in a cell | Excel Discussion (Misc queries) | |||
| identify data in a cell that has a number as the second character | Excel Worksheet Functions | |||
Hybrid Mode
