Auto Format of Data Entry

[Ark68]

I have a column of cells that the data takes on the same format...

N### ## ##

I just want to be able to quickly type in the 7 numbers (ie 1234567), and when I exit that cell it takes on the format N123 45 67.

How do I go about doing that?

 

[T. Valko]

Haha ... outstanding. Working wonderfully.
OK ... I know I said I needed to only go one more step further. But maybe I lied ... I have ONE additional function I'd like to do ....

Here is my formula:

=CONCATENATE($B292," ",$C292," ",LEFT(TEXT($G292,"""N""000 00 00"),4),".",MID(TEXT($G292,"""N""000 00 00"),6,2),".",RIGHT(TEXT($G292,"""N""000 00 00"),2),".000"," ",LEFT(TEXT($H292,"""W""000 00 00"),4),".",MID(TEXT($H292,"""W""000 00 00"),6,2),".",RIGHT(TEXT($H292,"""W""000 00 00"),2),".000","   ;",$D292,", ",$E292)

I'd like to add some colour to the result ...

ZFN 392 N064.54.24.000 W125.33.54.000 ;Tulita, NT

You'll need VBA code to do that.

I'm not much of a programmer so if you want to do this I suggest you start a new thread.