Results 1 to 6 of 6

Decimal places in linked cells

Threaded View

  1. #1
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Decimal places in linked cells

    Hi,

    Assume I have a formula in Cell A1 and this is linked to Cell A2 so that A2=A1. If the result of the formula is not a whole number then the number of numerals after the decimal are variable. Is there a way to standardize this (e.g. 00.00) without using vba? I know that you can do this cosmetically by using the cell formatting options, but is there a way for the actual number in linked cell to be the number of decimal places I need?

    Thanks in advance.

    abousetta
    Last edited by abousetta; 02-15-2011 at 08:28 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1