+ Reply to Thread
Results 1 to 10 of 10

Exporting of pdf converting to number

  1. 04-19-2024, 07:34 AM #1
    Switchblade IX
    Switchblade IX is offline
    Registered User
    Join Date
    06-18-2021
    Location
    Bloemfontein, south Africa
    MS-Off Ver
    2019
    Posts
    65

    Exporting of pdf converting to number

    Hi Everyone,

    I am running into a problem when exporting a pdf document to excel it does not convert the numbers at all.

    It exports as 10.00 even if I change the cell formatting to number it stays the same I have to physically re type the digits to be seen as a Number.

    I have attached the exported sheet Column B is the one in question.

    Any help would be appreciated.

    Thank you.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-19-2024, 07:35 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,162

    Re: Exporting of pdf converting to number

    Administrative Note:

    Is your forum profile showing the Excel PRODUCT that you need this to work for?

    Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.

    The three most recent Excel products are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.

    Thanks.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 04-19-2024, 07:38 AM #3
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,162

    Re: Exporting of pdf converting to number

    Type 1 into any spare cell > CTRL+C to copy the cell (not its contents).

    Select the whole of column B > right-click > Paste Special > Paste Special > Multiply > OK.
    Reply With QuoteRegister To Reply
  4. 04-19-2024, 07:59 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,162

    Re: Exporting of pdf converting to number

    Any questions?
    Reply With QuoteRegister To Reply
  5. 04-19-2024, 08:02 AM #5
    Switchblade IX
    Switchblade IX is offline
    Registered User
    Join Date
    06-18-2021
    Location
    Bloemfontein, south Africa
    MS-Off Ver
    2019
    Posts
    65

    Re: Exporting of pdf converting to number

    Hi AliGW,

    Thank you for the prompt reply,

    I updated my profile as requested

    For some reason still not managing with the numbers
    Reply With QuoteRegister To Reply
  6. 04-19-2024, 08:07 AM #6
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,162

    Re: Exporting of pdf converting to number

    What do you mean? I tested it in your workbook and it converted everything to numbers.
    Attached Files Attached Files
    Last edited by AliGW; 04-19-2024 at 08:12 AM.
    Reply With QuoteRegister To Reply
  7. 04-19-2024, 08:15 AM #7
    Switchblade IX
    Switchblade IX is offline
    Registered User
    Join Date
    06-18-2021
    Location
    Bloemfontein, south Africa
    MS-Off Ver
    2019
    Posts
    65

    Re: Exporting of pdf converting to number

    I also just managed to do that but then they dont want to add up in a sum or any other formula after converting.
    Reply With QuoteRegister To Reply
  8. 04-19-2024, 08:17 AM #8
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,162

    Re: Exporting of pdf converting to number

    That's not true if you've done it properly - see the attached.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  9. 04-19-2024, 08:34 AM #9
    Switchblade IX
    Switchblade IX is offline
    Registered User
    Join Date
    06-18-2021
    Location
    Bloemfontein, south Africa
    MS-Off Ver
    2019
    Posts
    65

    Re: Exporting of pdf converting to number

    Thank you very Much AliGW I really really appreciate your help I managed.
    Reply With QuoteRegister To Reply
  10. 04-19-2024, 09:11 AM #10
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,162

    Re: Exporting of pdf converting to number

    Good-oh! Glad to have helped.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] micro button for converting/exporting the selected sheets to one pdf file
    By meonly123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2023, 12:46 AM
  2. [SOLVED] Converting a text and number time into a numerical value and converting to minutes
    By RQuilley in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-07-2020, 11:40 AM
  3. Converting number to actual text of number (spelling out the number)
    By rfigueroa1976 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-18-2019, 11:05 AM
  4. Checking the Sum while exporting Number data?
    By devpp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-22-2013, 04:27 AM
  5. exporting portions of DB, & append file number to db
    By phenicie in forum Access Tables & Databases
    Replies: 1
    Last Post: 12-28-2011, 12:29 PM
  6. Exporting to Excel Number Format Issue
    By johnrriggs22 in forum Excel General
    Replies: 2
    Last Post: 12-13-2010, 11:39 AM
  7. [SOLVED] using multiple mso-number-format's when exporting using HttpResponse
    By Mark Iverson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-09-2006, 01:35 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1