+ Reply to Thread
Results 1 to 2 of 2

Convert Percentage to 5 digit number without decimal point

  1. #1
    Forum Contributor
    Join Date
    07-31-2009
    Location
    Lincoln, USA
    MS-Off Ver
    Excel 2007 and excel 2010
    Posts
    140

    Convert Percentage to 5 digit number without decimal point

    hello all and thank you in advanced.

    I have a upload process where I have to upload percentages as a 5 digit number with no decimal points and I'm having troubles getting excel to do this and retain all characters and would appreceate some help.

    Examples

    - Original Number = 6.8% (0.068)
    - Needs to Display as = 00680


    - Original Number = 7.2%
    - Needs to Display as = 00720

    - Orignal Number = 10%
    - Needs to Display as = 01000

    - Orignal Number = 150%
    - Needs to Display as = 15000


    The issue is I need it to completely remove the decimal and keep any leading or trailing zeros.

    thoughts appreceated.

    thanks again.
    Last edited by fireguy7; 02-16-2015 at 06:06 PM.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Convert Percentage to 5 digit number without decimal point

    Row\Col
    A
    B
    C
    1
    6.80%
    00680 B1: =TEXT(10000*A1, "00000")
    2
    7.20%
    00720
    3
    10%
    01000
    4
    150%
    15000
    Entia non sunt multiplicanda sine necessitate

+ 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. insert decimal point after first digit
    By henrikgb in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 11-07-2014, 07:57 AM
  2. Replies: 3
    Last Post: 04-24-2012, 09:16 AM
  3. [SOLVED] Add decimal point from last 2 digit
    By transferxxx@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2006, 08:05 AM
  4. Display a digit before or after the decimal point in another cell
    By Robert Monks in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-03-2005, 05:25 AM
  5. In excel, how can i delete 1 digit and the decimal point?
    By rjtees in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-17-2005, 05:50 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