+ Reply to Thread
Results 1 to 2 of 2

Add one decimal place to each cell in a range

Hybrid View

  1. #1
    Registered User
    Join Date
    06-04-2012
    Location
    Ohio
    MS-Off Ver
    MS Office 2003, 2007, 2010
    Posts
    14

    Question Add one decimal place to each cell in a range

    I would like to be able to add one decimal place to each cell in my range.

    Example:

    111.111 becomes 111.1110

    22.22 becomes 22.220

    3.3 becomes 3.30

    There are no standards here, I just want to be able to add that last decimal place. I need cells to remain in "Number" format also.

    Thanks!

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Add one decimal place to each cell in a range

    Hi,

    Why not use the small increase decimals icon in the Number pane on the ribbon?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Check/Validate range for 4 decimal place input only
    By aprusik in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-01-2013, 07:59 PM
  2. Decimal Place Help
    By cadk73 in forum Excel General
    Replies: 4
    Last Post: 02-14-2012, 08:11 PM
  3. Decimal Place
    By Pale Cloud in forum Excel General
    Replies: 6
    Last Post: 04-06-2011, 05:54 AM
  4. Replies: 3
    Last Post: 03-18-2006, 02:25 PM
  5. Highest & lowest place value / decimal places of cell value
    By Neil Goldwasser in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-15-2006, 10:30 AM

Tags for this Thread

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