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?
Hi Spektre,
I don't think you can use any kind of worksheet functions within custom formats, so you would need to do this via a macro - probably in the worksheet's Change event based on the cells/columns you're entering data into.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks