I have an excel sheet with in the first column A

01.
01.01
01.02
01.03
01.03.01
01.03.02
02.
02.01

etc....

I need a way to somehow check if the sequence is always upcounting lik
for example if there's somewhere an error like

02.01
02.01

or 02.01, 02.03 this will be corrected by a formula or macro or..
whatever, just a way to correct this

note: also the format has to stay xx.xx.xx.x

--
supe
-----------------------------------------------------------------------
super's Profile: http://www.excelforum.com/member.php...fo&userid=2433
View this thread: http://www.excelforum.com/showthread.php?threadid=37934