+ Reply to Thread
Results 1 to 3 of 3

Problem with numeric input

  1. #1
    Registered User
    Join Date
    12-17-2019
    Location
    Tallin, Estiona
    MS-Off Ver
    2019
    Posts
    2

    Problem with numeric input

    Hello everyone!

    I have a problem with numeric input (decimal places). For example when im entering a number 16,48 in a cell it looks right but in formula bar it shows 16,4807150561798 instead of 16,48. How do i fix this, so that cell number is equal to the number in the formula bar?
    In other excel there are no such problems.

    Screenshot:
    Screenshot 2019-12-17 at 15.49.03.png

    Thanks in advance for any help!
    John!
    Attached Files Attached Files
    Last edited by desikik; 12-17-2019 at 04:15 PM.

  2. #2
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    24,318

    Re: Problem with numeric input

    I don't think I have seen this before!!

    Please attach a sheet showing this problem (read yellow banner at the top of the screen for guidance on attaching a file).
    Glenn



  3. #3
    Registered User
    Join Date
    12-17-2019
    Location
    Tallin, Estiona
    MS-Off Ver
    2019
    Posts
    2

    Re: Problem with numeric input

    Quote Originally Posted by Glenn Kennedy View Post
    I don't think I have seen this before!!

    Please attach a sheet showing this problem (read yellow banner at the top of the screen for guidance on attaching a file).
    Thanks for the reply!

    As i said, there is no problem with other PCs. It is only for one. I would like to solve this problem without reinstall excel.

    File in attachment.

+ Reply to Thread

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