In this tutorial I demonstrate how to display numbers and dates correctly when they are embedded within a text entry.
The screenshot below is from a simple loan calculator. The sentence in A7 is generated by combining the contents of B3, B4 and B5 with static text
However, if you simply enter
=B4 & ” payments of ” & B3 & ” will be taken from your account starting on ” & B5
You will get this:
The video below shows how to format the number and date to display correctly: