Thread: How do I Limit decimal places in a string cell reference
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default How do I Limit decimal places in a string cell reference
Use this:

=TEXT(A1,"0.0")

or something like this:

="Result is: "&TEXT(A1,"0.0")

Hope this helps.

Pete

On Dec 29, 2:41*pm, Ozinus wrote:
I am referencing a cell which has 1 decimal place yet it shows about 12
places right of the decimal in the string. What am I doing wrong?

Reply With QuoteReply With Quote