Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic Numbering | Excel Worksheet Functions | |||
Automatic numbering | Excel Discussion (Misc queries) | |||
Automatic Numbering | Excel Worksheet Functions | |||
automatic numbering | Excel Worksheet Functions | |||
Automatic Numbering. | Excel Discussion (Misc queries) |