It looks like the criteria is when the number reaches a multiple of 100, is
that correct?

--
__________________________________
HTH

Bob

"Pai" wrote in message
...
I have a Data in Column A

i want to Give the Number like this

1
2
3
4
5
Blank
101
102
103
104
Blank
201
202
203
204
205
Blank
301
302
303
304
305
306
And So on

Thanks in Advance

Hardeep kanwar