View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default Paragraph numbering 1.1.1

I do a lot of that type of work myself, although I generally don't bring
Project into it - but to the best of my knowledge there's no similar feature
in Excel (if someone shows that there is, boy will I be a happily surprised
camper).

I could see building a custom VBA function to do it, but you'd need to use
individual adjacent columns for each paragraph level:
A = major paragraph #s as 1, 2, 3
B = next level as 1.1, 1.2, 2.1, 2.3, etc
C = next level as 1.1.1, 1.1.2 and so on
D = next level
You could carry that out as far as you need to go with regard to paragraph
"depth", I suppose.


"BCNU" wrote:

I am trying to tie a Work Breakdown Structure in Project to a Statement of
work in Word and track costs in Excel. The statement of work uses paragraph
numbers like 1.0, 1.1, 1.1.1, 1.2 etc. Is there a way to have excel autofill
or genrate these numbers (like word does)?
--
Thanx