Passing cell value with decimal-format

**Figdor** · 08-14-2012, 09:03 AM

Hello.

I have a cell, A1 say, with value 0.1245433212 that I have rounded using the toolbar so that the cell now shows 0.12.

In another cell I want to pass the rounded value of A1 by refering to its cell address, i.e. the number 0.12. However if I refer to the cell by for instance letting the formula for A2 be "My A1 value = "&A1 it will pop out "My A1 value = 0.1245433212" in cell A2.

Is there a Excel function that can help me to pop out the rounded animal?

I would like to control the rounding by rounding the original value in A1 and not use the ROUND()-function on A2. Of course, if there is a function to return how much my value in A1 is rounded that is just great.

Best regards.

**K m** · 08-14-2012, 09:07 AM

Try fixed

=fixed(a1,2)

**Figdor** · 08-14-2012, 09:38 AM

Hey, thanks.

But that is not solving my problem.I would like to control the decimals showing in A2 from the way A1 is rounded. I do not want to let the number of decimals be shown in any ROUND() og FIXED() function unless the decimal-number can be returned from A1 by some way (with a function for instance).

**DGagnon** · 08-14-2012, 10:53 AM

you could use a custom function like this:

Function DecRnd(c As Range)
    DecRnd = Format(c.Value, c.NumberFormat)
End Function

and in cell 2 you would enter something like this

=DecRnd(A1)

**Figdor** · 08-14-2012, 01:06 PM

Good idea!! I got it working. Is there way that I can have my functions be automatically updated?? That is, I have defined my function getRoundedValue() which return the value that is shown in the cell.

When I change the way the values are rounded in A1, the function doesn't recalculate to update A2.

**DGagnon** · 08-14-2012, 02:07 PM

Try this

Function DecRnd(c As Range)
    Application.Volatile
    DecRnd = Format(c.Value, c.NumberFormat)
End Function

**Pauleyb** · 08-14-2012, 02:35 PM

This may be able to be reduced, but I think it is interesting:
=--TEXT(A1,"#."&REPT("#",RIGHT(CELL("format",A1),1)))

Passing cell value with decimal-format

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Passing cell value with decimal-format

Re: Passing cell value with decimal-format

Re: Passing cell value with decimal-format

Re: Passing cell value with decimal-format

Re: Passing cell value with decimal-format

Re: Passing cell value with decimal-format

Re: Passing cell value with decimal-format

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions