Decimal Places

[Guest]

I am trying to use the following formula to display a text version of a number:

=TEXT(cell,"#.#")

To show numbers in a 0.0 format.

However, when I get to one figure 20.0 - it displays it as 20. rather than
as 20.0 (which is how I would like it to be displayed).

Does anyone know how to display the information in this format??

 

[Pete_UK]

Try this:

=TEXT(cell,"0.0")

Hope this helps.

Pete

 

[Guest]

Thanks that worked great.

Try this:

=TEXT(cell,"0.0")

Hope this helps.

Pete

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

Thanks that worked great.





- Show quoted text -