+ Reply to Thread
Results 1 to 2 of 2

integer number to decimal

  1. #1
    Registered User
    Join Date
    06-13-2016
    Location
    Turkey
    MS-Off Ver
    16
    Posts
    30

    integer number to decimal

    Hi all, I have a lot of integer numbers in columns "A" and I need to covert them to decimal, same as below as below :

    column A ....... column B
    ..........................................
    5644840 >>> 56.4484
    5645035 >>> 56.45035
    5645950 >>> 56.4595
    5645509 >>> 56.45509
    5646091 >>> 56.46091

    I need column "b".

    can someone help me?

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2024
    Posts
    6,175

    Re: integer number to decimal

    Try:

    =A1/100000

+ 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. [SOLVED] VB code to convert number to integer and 2 decimal
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-20-2017, 07:46 PM
  2. decimal field of a number is changing when I strip off the integer field.
    By whburling in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-08-2017, 12:33 PM
  3. Replies: 2
    Last Post: 05-17-2016, 11:17 AM
  4. Replies: 2
    Last Post: 11-19-2015, 09:20 AM
  5. Decimal number changes to integer
    By nickjnford in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2013, 06:32 AM
  6. Count the number of occurrences of an integer withing a larger integer
    By nnktran in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-26-2010, 01:04 PM
  7. [SOLVED] excel-enter integer number and get two decimal places
    By Jack H in forum Excel General
    Replies: 2
    Last Post: 10-16-2005, 05: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