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.

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

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.

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.

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