Thursday, October 11, 2012

yogi_Formulate Table Of Contents Type Numbering System Increasing The Digit To The Furthest Right By 1


Yogi Anand, D.Eng, P.E.      Google Spreadsheet   Post  #802  Oct 11, 2012    www.energyefficientbuild.com.

user Dave_OCNL said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/VTARFlLuK48)
Formatting Numbers in Google Spreadsheets
Hello, 
I am using Firfox 15 and am trying to create a number sequence of:

1.0
1.0.1 
1.0.2
~
1.1.0
1.1.1
1.1.1.1
1.1.1.2

and so on 

Can anyone suggest a formula that will increment the digit furthest to the right by 1?
Thanks -

Dave

--------------------------------------------------------------------------------------------------------
following is a solution to the problem