Excel Study · Module 2: Entering & formatting data
Class 11Number formats that look pro
Basics1:53 videoFree
Make a report look professional in seconds. Comma Style adds a thousands separator and two decimals, Currency adds your computer's own currency symbol, and Percent Style shows a share as a percentage — Increase Decimal adds one more digit.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, cell B2 has the number 45250.5. Write a formula for B7 that shows it as text with a thousands separator and 2 decimal places.
The answer that works
✓ checked in Excel=TEXT(B2,"#,##0.00")
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.