+ Reply to Thread
Results 1 to 5 of 5

Typing without decimals

  1. #1
    Registered User
    Join Date
    05-15-2020
    Location
    Denmark
    MS-Off Ver
    2016
    Posts
    1

    Typing without decimals

    Is it possible for me to format a range of cells in a spreadsheet, so when I type a number, then it automatically formats to 1 decimal.

    For example...

    If I enter 79, I want the cell to display 7,9 - If I enter 100, I want it the cell to display 10,0.

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Typing without decimals

    a custom number format of 0\,0 will mask 79 as 7,9 etc

    note underlying value remains 79

    if you want to convert the underlying value from 79 to 7,9 on entry, in same cell, you would need to use VBA
    (there is an XL option to do this [automatically insert a decimal point] but it applies universally - so generally a bad idea... )

  3. #3
    Forum Expert
    Join Date
    05-01-2014
    Location
    California, US
    MS-Off Ver
    Excel 2010
    Posts
    1,795

    Re: Typing without decimals

    [.... deleted by me ....]
    Last edited by joeu2004; 05-15-2020 at 03:57 PM.

  4. #4
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Typing without decimals

    Quote Originally Posted by joeu2004 View Post
    ...for the latter, set the option "Automatically insert decimal point".
    per post #2, which the above basically repeats, this should not be used without caution as it applies universally.

  5. #5
    Forum Expert
    Join Date
    05-01-2014
    Location
    California, US
    MS-Off Ver
    Excel 2010
    Posts
    1,795

    Re: Typing without decimals

    Quote Originally Posted by XLent View Post
    per post #2, which the above basically repeats, this should not be used without caution as it applies universally.
    Sorry. Somehow I overlooked that comment in your posting. Klunk! And agree with the caution.

+ 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. Rounding 2 decimals to specific 2 decimals
    By danyel191 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-28-2016, 01:41 PM
  2. Replies: 2
    Last Post: 02-13-2015, 07:36 AM
  3. Typing and adding more
    By laughingasian in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 02-09-2013, 06:27 AM
  4. Typing in VB
    By pynchon in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-22-2006, 04:10 AM
  5. [SOLVED] Help typing formula
    By kgoldner in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-13-2006, 10:20 PM
  6. typing fractions
    By suzijames in forum Excel General
    Replies: 3
    Last Post: 01-12-2006, 05:55 PM
  7. text typing
    By lammy122 in forum Excel General
    Replies: 3
    Last Post: 08-21-2005, 12:05 PM

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