+ Reply to Thread
Results 1 to 4 of 4

Formula in Custom Number Format

  1. #1
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Formula in Custom Number Format

    hi all...

    i need formula or ticks to figure out this problem Custom Number Format

    30.000 -----US$ 30.000
    688.000.000----US$ 688.000.000
    100 ----US$ 100
    12.000.000 -----US$ 12.000.000

    mark dot (.) not decimal...

    thanks

    john m
    Attached Files Attached Files

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Formula in Custom Number Format

    Sorry, I should've read carefully.
    Last edited by AlKey; 01-28-2017 at 12:26 PM.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Re: Formula in Custom Number Format

    hi alkey, display "cannot use....."

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Formula in Custom Number Format

    Administrative Note:
    HTH
    Regards, Jeff

+ 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] Custom Number Format Formula
    By rosethorn5 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 08-04-2015, 09:25 AM
  2. Need formula or code to convert number(s) from custom format to number format
    By tuongtu3 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-12-2015, 07:44 PM
  3. Conveying custom number format to new cell via formula
    By delirium in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-03-2009, 12:36 PM
  4. custom number format in formula
    By pbruce61 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-20-2007, 10:19 AM
  5. how do I add phone number format as a permanent custom format?
    By frustratedagain in forum Excel General
    Replies: 3
    Last Post: 02-03-2006, 11:52 PM
  6. Format a cell with a custom number format
    By Armor in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-29-2006, 07:30 PM
  7. [SOLVED] Custom number format always defaults last number to 0.
    By scubadave in forum Excel General
    Replies: 2
    Last Post: 06-15-2005, 06: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