Number to Text

  • Thread starter Thread starter George
  • Start date Start date
G

George

I have an excel file that was sent to me from another
company.
The data that I need has been defined as a number.
eg 123.50
When I try to change the cell to text the results become:
123.5
I lose the zero at the end.
I have tried to concat, left, right with no luck.
Do you know how to convert this cell from number to text
and keep the last zero?
 
George

if the data is in cell A1, then: =TEXT(A1,"0.00")

Regards

Trevor
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert column of numbers to text. 2
Value Sum 3
Changing Text To Numbers ? 1
Custom Number Format for text 8
Convert number in to words 2
Leading Zero Dropped in Text Cell 3
Numbers stored as text 4
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1

Back
Top