EXCEL：流水號的製造
===================================
A1的值2014
="S"&RIGHT(A$1,2)&TEXT(ROW(A1),"-000000")
產生：S14-000001
=====================================
==TEXT(ROW(A1),"000000")
產生：000001
=====================================
-
================== Range("A1").Select With Selection .HorizontalAlignment = xlLeft '水平對齊 .VerticalAlignment = xl...
-
儲存格 [R1C1]格式，[A1]格式 Cells(列次，欄次).Select Cells(2, "A").Select '2列A欄 Cells(2, 1).Select '2列1欄 Cells.Item(5,”C”...
沒有留言:
張貼留言