Excel Study · Module 5: Text functions
Class 45TEXT: numbers inside sentences
Intermediate2:03 videoFree
Join a name and an amount with & and Excel drops the number's format: the cell shows 4,250.50 but the sentence says Ravi paid 4250.5.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, A2 has a customer's name and B2 the amount they paid, like 4,250.50. Write a formula for C6 that makes a sentence like Ravi paid 4,250.50, with the amount always shown with a comma and two decimals. Use the & operator.
The answer that works
✓ checked in Excel=A2&" paid "&TEXT(B2,"#,##0.00")
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.