Thread: How can I cap numbers in a column? (Workbook included)
View Single Post
 
Old 03-19-2020, 02:13 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
Until "00.39.39" this formula will do. After this you have to add another calculation level (the logic remains same).
Code:
="00." & RIGHT("00"&MOD(INT((ROW()-1)/40),40),2) & "." & RIGHT("00"&MOD(ROW()-1,40),2)
Reply With Quote