CODEWITHSUNDEEP
excelexcel-formula
All The Rage
All The Rage

Reputation: 831

In Excel, how do I convert a fractional number to text like "234.5" but a whole number to text like "234"?

In Excel, how do I convert a fractional number to text like "234.5" but a whole number to text like "234"? If I do =text(234, "0.0") it gives 234.0, but I want "234". If I do =text(234.5, "0") it gives 235,but I want 234.5.

Upvotes: 1

Views: 93

Answers (1)

pnuts
pnuts

Reputation: 59460

If you want numbers to be changed to Text format without other changes in appearance one way is with:

=A1&""

Upvotes: 2

Related Questions