Hellow all,
I made a custom cell format that does the following:
FIGURE 1
Typed: 2413001500
Output: 241300Z-1500Z
Now what I would like is to do this:
FIGURE 2
Type: 13001500
Output: 241300Z-1500Z
This is my current format: _(######Z-####Z
The '24' you see is the day of the month. How can I tell excell to auto input the day of the month as shown in fugure two?
Bookmarks