|
Automatic List Numbering
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 |
Automatic List Numbering
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 |
Automatic List Numbering
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 |
Automatic List Numbering
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 |
| All times are GMT +1. The time now is 12:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com