+ Reply to Thread
Results 1 to 7 of 7

Need formula or code to convert number(s) from custom format to number format

  1. #1
    Forum Contributor
    Join Date
    08-14-2012
    Location
    USA
    MS-Off Ver
    Excel 2007, MS 365 (Windows 10 Pro 64-bit)
    Posts
    810

    Need formula or code to convert number(s) from custom format to number format

    Hello All,
    Please help me with the formula or code to converts number(s) from custom format to number format:

    8
    10.0
    1.1
    4.10
    12.5
    82.10
    126.8
    245.11


    Regards,
    tt3

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Need formula or code to convert number(s) from custom format to number format

    Quote Originally Posted by tuongtu3 View Post
    converts number(s) from custom format to number format:
    What do you mean by Custom Format to Number Format?

    Please make your query clear for my better understanding


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Contributor
    Join Date
    08-14-2012
    Location
    USA
    MS-Off Ver
    Excel 2007, MS 365 (Windows 10 Pro 64-bit)
    Posts
    810

    Re: Need formula or code to convert number(s) from custom format to number format

    Hi Sixthsense ,
    Please see attached and keep the same decimal places (because my code did not recognized "custom" format)

    (The custom format from converting PDF to excel)

    Regards,
    tt3
    Attached Images Attached Images
    Last edited by tuongtu3; 01-12-2015 at 03:58 AM.

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Need formula or code to convert number(s) from custom format to number format

    Thanks for the screenshot but still I am puzzled about what is your actual requirement

    Can you please attach a sample workbook with expected result?

  5. #5
    Forum Contributor
    Join Date
    08-14-2012
    Location
    USA
    MS-Off Ver
    Excel 2007, MS 365 (Windows 10 Pro 64-bit)
    Posts
    810

    Re: Need formula or code to convert number(s) from custom format to number format

    Hi Sixthsense,
    Please see attached and keep the same decimal places (because my code did not recognized "custom" format)

    (The custom format from converting PDF to excel)

    Regards,
    tt3
    Attached Files Attached Files

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Need formula or code to convert number(s) from custom format to number format

    Why don't you simply press Ctrl+A to select all cells and apply the desired Number formatting?

    Or

    Still am I missing your point?

  7. #7
    Forum Contributor
    Join Date
    08-14-2012
    Location
    USA
    MS-Off Ver
    Excel 2007, MS 365 (Windows 10 Pro 64-bit)
    Posts
    810

    Re: Need formula or code to convert number(s) from custom format to number format

    Hi,
    It does not work because how do I keep the same decimal after converting to number

    1.8 ===> 1.8
    2.11 ===> 2.11

    Regards,
    tt3

+ 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. Replies: 5
    Last Post: 01-08-2015, 04:55 PM
  2. Replies: 1
    Last Post: 12-15-2014, 08:46 PM
  3. Cannot use Custom Number Format. Need help with a VBA code
    By Linus100 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-12-2014, 05:16 PM
  4. Custom number format code for hiding specific values on chart axes
    By rob_storrar in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-25-2012, 12:27 AM
  5. custom number format in formula
    By pbruce61 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-20-2007, 10:19 AM

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