Excel has a problem combining cells that contain text and dates. This results in the date showing up as a number value because Excel has lost the format. To get the desired result, use the following workaround.
To combine text and date:
1. Select cell A1 and type actual status.
2. Select cell D1 and type the following formula: =TODAY().
3. Select cell A3 and type the following formula: =A1& " " &TEXT(D1,"MM/DD/YYYY").
COMBINE TEXT AND DATE USING MICROSOFT EXCEL |
Microsoft Excel Tutorials, Combine Text and Date using Microsoft Excel, Date Function, Microsoft Excel Video Tutorials, Advanced Excel Tutorials
No comments:
Post a Comment