Skip to main content

Featured

Golden Rules Of Investment

12 GOLDEN RULES OF INVESTMENT Live by these 12 rules and let your money grow!  1) The past is irrelevant –   Do not rely on past performances and build castles in the air. Invest for tomorrow and live for today.  2) Opinions can hurt. Don’t ask too many people –   just don’t!! To each, his own. What works for someone else, may not work for you and vice-versa. Your investment plan should be as unique as the back of your hand. More importantly, it must suit you best.  3) Everyone’s journey is different. Understand yours. –   Do not invest if you’re not clear on the purpose. Do not draw parallels with other investors. Your need for investing, risk appetite, and nature of investments is of utmost importance. You need to understand what you are doing.  4) Don’t allow your ego to engage with professional advice –   Trust your financial advisor! Google can give you lots of information but your advisor will tell you what’s best for you. Listen and then act!  5) Overthinking will never allow
Post a Comment
Read more
Labels

Using text and numbers together in excel

 Using Text And Numbers Together In Excel

Now we'll use the & to join text and numbers, not just text and text

Look at cells C28:D29. See how the date and times are in separate cells? You can join them together with the & symbol like you'll see in cells C32:C33, but that doesn't look right does it? Unfortunately, Excel doesn't know how you want to format the numbers, so it breaks them down to their basest format, which is the Serial date in this case. We need to explicitly tell Excel how to format the number portion of the formula, so it displays the way you want in the resulting text string. You can do that with the TEXT function and a format code.

1. In cell C36, enter =C28&" "&TEXT(D28, "MM/DD/YYYY"). MM/DD/YYYY is the US format code for Month/Day/Year, like 09/25/2017.

2. In cell C37, enter =C29&" "&TEXT(D29, "HH: MM AM/PM"). HH: MM AM/PM is the US format code for Hours: Minutes AM or PM, Iike 1:30 PM.



Labels:

Comments

Post a Comment

Popular Posts