David

I am when I do the sorting, the rest of data can be sorted, but the serial
no. keep the same (doesn't follow the record)

Tks
Tony



"David Biddulph" wrote:

What do you mean by "But I can't do any sorting"?
--
David Biddulph

"Tony" wrote in message
...
Hi

I am writing a formula to generate a serial number automatically. I use
"A1+1" in cell B1. A1=0, then each record will increase. But I can't do
any
sorting. On the other hand, I don't want to change the formula into a
value
then I can do sorting. Can anyone help please please?? (Don't be too
technical, I am not very good with computer, thanks)


Tony