Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
general:tipsoftheday [2019/11/05 15:55]
gerardorourke [Windows Command line]
general:tipsoftheday [2019/11/08 11:29] (current)
gerardorourke [Sort IP address]
Line 13: Line 13:
 =TEXT(MID(A1,​1,​FIND("​.",​A1)),"​000"​)&"​."&​TEXT(MID(A1,​FIND("​.",​A1)+1,​FIND("​.",​A1,​FIND("​.",​A1)+1)-1-FIND("​.",​A1)),"​000"​)&"​."&​TEXT(MID(A1,​FIND("​.",​A1,​FIND("​.",​A1)+1)+1,​FIND("​.",​A1,​FIND("​.",​A1,​FIND("​.",​A1)+1)+1)-1-FIND("​.",​A1,​FIND("​.",​A1)+1)),"​000"​)&"​."&​TEXT(MID(A1,​FIND("​.",​A1,​FIND("​.",​A1,​FIND("​.",​A1)+1)+1)+1,​LEN(A1)),"​000"​) =TEXT(MID(A1,​1,​FIND("​.",​A1)),"​000"​)&"​."&​TEXT(MID(A1,​FIND("​.",​A1)+1,​FIND("​.",​A1,​FIND("​.",​A1)+1)-1-FIND("​.",​A1)),"​000"​)&"​."&​TEXT(MID(A1,​FIND("​.",​A1,​FIND("​.",​A1)+1)+1,​FIND("​.",​A1,​FIND("​.",​A1,​FIND("​.",​A1)+1)+1)-1-FIND("​.",​A1,​FIND("​.",​A1)+1)),"​000"​)&"​."&​TEXT(MID(A1,​FIND("​.",​A1,​FIND("​.",​A1,​FIND("​.",​A1)+1)+1)+1,​LEN(A1)),"​000"​)
 </​code>​ </​code>​
 +
 +==Insert a picture into an excel cell==
 +  *Right click Picture -> Format Picture -> Properties -> Move and size with Cell
 +  *Reference: https://​www.journalofaccountancy.com/​issues/​2018/​oct/​insert-image-into-an-excel-cell.html
 +
 +