How do I Limit decimal places in a string cell reference
 

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?

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?

How do I Limit decimal places in a string cell reference
 

The cell DOING the referencing isn't formatted properly.

CTRL+1 will open the format box.

You need to be careful with references, your problem shows how data can
LOOK one way but actually be another. The cell you're referencing
appears to have a long calculated value in it with many decimal places.
It is formatted to only show 1 decimal place...which is usually OK.

But if you start doing calculations against that cell, you'll start to
notice discrepancies in the resulting math. That's because the number is
really much longer than you're seeing.

To eliminate the discrepancy, you need to round off those values
properly. Look at the help files on ROUND and MROUND. You can do the
rounding in the cell itself or in the cells that reference that cell,
just remember to do it.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=44794

How do I Limit decimal places in a string cell reference
 

Either
a) format the cell to display only 1 decimal place
or
b) use a formula such as =ROUND(A1,1) to round the actual stored value to
one decimal place
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Ozinus" wrote in message
...
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?

How do I Limit decimal places in a string cell reference
 

Another way is to use FIXED function, i.e.

=FIXED(A1,1)