LinkBack URL
About LinkBacks
Try
or
=CONCATENATE(TEXT(A1,"000000000"),"-",TEXT(B1,"00000"),"-",TEXT(C1,"00000"))
=TEXT(A1,"000000000")&"-"&TEXT(B1,"00000")&"-"&TEXT(C1,"00000")
Try
or=CONCATENATE(TEXT(A1,"000000000"),"-",TEXT(B1,"00000"),"-",TEXT(C1,"00000"))
=TEXT(A1,"000000000")&"-"&TEXT(B1,"00000")&"-"&TEXT(C1,"00000")
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks