Hi
I want to generate this
COB-01/04
COB-02/04
COB-03/04
and so on in a column but I have absolutely no idea how to do it or if it is even possible. If anyone can help me I'll be delighted
thanks a lot!
Hi
I want to generate this
COB-01/04
COB-02/04
COB-03/04
and so on in a column but I have absolutely no idea how to do it or if it is even possible. If anyone can help me I'll be delighted
thanks a lot!
I would use 3 columns: COB- in first, 01 in second, and /04 in third column. Close the column widths up. COB- and /04 can be filled down and remain unchanged, 01 can be filled in series. The problem I found with trying to put COB-01/04 in a single cell was that the cell became text, and the /04 was treated as a year, so getting /04, /05, /06, and so on, yet 01 stayed as 01.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks