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?