To make a contribution by Pay Pal in USD ($ US) -Īny liability for loss or damage to data to which any techniques, methods or code included in this website are applied. To make a contribution by Pay Pal in GBP (£ sterling). Please support this website by making a donation to help keep it free of advertising and to help towards cost of time spent adding new content. So if you are copying it into Excel, make certain that no spaces appear in the formula and that the formula is not split across more than on cell Note that the formula is one long one with no spaces. That formula yields the result 121415ZJUL2018 in cell B1. ![]() ![]() I’ve been unable to create a custom format that will capitalise the Jul, so to achieve this I have used this formula I understand that sometimes the format requires JUL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |