Hi Devon

glad its solved.

Cheers
JulieD

"Devon T. Sowell" wrote in message
...
Thanks for the quick reply.
Yep, the cells were formatted as text.
Best Regards,
Devon T. Sowell
www.3-ddesignsolutions.com

"JulieD" wrote in message
...
Hi Devon

i have no problem with the formula, so my first guess would be that the
cells were formatted as text prior to entry of the data - insert a new
column and give that a go. Additionally, you might have your workbook
set
up to display formulas instead of their results - try tools / options /
view - and untick formulas.

Hope this helps
JulieD

"Devon T. Sowell" wrote in message
...
Automatic List Numbering
I can't get John Walkenbach's tip to work.
I use the formula =IF(B1<"",COUNTA($B$1:B1)&".","")
The list numbers don't display, just the formulas.
Thanks in advance,
Devon T. Sowell
www.3-ddesignsolutions.com