Another way to try out ..

Put in any starting cell, say A2:

="NAR "&TEXT(ROWS($A$1:A1),"0.00")

Copy A2 down

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"clambake5" <clambake5@discussions.microsoft.com> wrote in message
news:EE5610E2-35C9-46FF-B2BC-A5F6B9A85FC8@microsoft.com...
> How do I create an alpha numeric cell example NAR 1.00 then NAR 2.00?