how can i format the cell with automatic colon in in every secon
alphanumeric

when i type>>>>>>>>>>>>>> 00ED078125EA
FORMAT MUST BE THIS >>>>>>> 00:ED:07l:81:25:E

--
xtrmhype
-----------------------------------------------------------------------
xtrmhyper's Profile: http://www.excelforum.com/member.php...fo&userid=2385
View this thread: http://www.excelforum.com/showthread.php?threadid=49171

Since the entry is alphanumeric, XL treats it as Text, and no formatting
will give you what you're after.

You could use a Worksheet Event macro to modify the entry to include
colons, but that would actually change the entry, which formatting does
not. Is that what you're after?


In article <(E-Mail Removed)>,
xtrmhyper <(E-Mail Removed)>
wrote:

> how can i format the cell with automatic colon in in every second
> alphanumeric
>
> when i type>>>>>>>>>>>>>> 00ED078125EA
> FORMAT MUST BE THIS >>>>>>> 00:ED:07l:81:25:EA

up for this!
still no answer!


--
xtrmhyper
------------------------------------------------------------------------
xtrmhyper's Profile: http://www.excelforum.com/member.php...o&userid=23851
View this thread: http://www.excelforum.com/showthread...hreadid=491717

Have you rejected John McGimpsey's suggestion or did you not see his posting?

If you did see it, are you having a problem implementing it?

Here's the text of John's reply to you.

"Since the entry is alphanumeric, XL treats it as Text, and no formatting
will give you what you're after.

You could use a Worksheet Event macro to modify the entry to include
colons, but that would actually change the entry, which formatting does
not. Is that what you're after?"


Gord Dibben MS Excel MVP

On Thu, 19 Jan 2006 22:05:42 -0600, xtrmhyper
<(E-Mail Removed)> wrote:

>
>up for this!
>still no answer!