Number format after import from Excel

  • Resolved Hairshirt

    (@hairshirt)


    2 years, 5 months ago

    Hello Tobias,

    Thanks you for a very useful plugin…

    I have a small problem… All my tables are produced in Excel and imported into Tablepress… All is good and works just as expected except for one problem that I have.

    I end-up with numbers like this…: 416.0364 instead of how they are presented in Excel: 416.04 (also rounded-up to the next penny).

    Also, for some larger numbers, the separator between thousands and hundreds is missing and I end-up with numbers like this: 1145.0352 instead of @ 1,145.03…

    I’ve been racking my brain over this problems for some time now… Can you help?.. Many thanks

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    Unfortunately, the Excel import can indeed not properly detect the used number formats at this time.
    My recommendation therefore is to save the table to a CSV file from within Excel and then import that CSV file into TablePress. This should result in the number formats as you are seeing it on screen in Excel.

    Regards,
    Tobias

    Thread Starter Hairshirt

    (@hairshirt)

    Many thanks, Tobias ??

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    no problem, you are very welcome! ?? Good to hear that this helped!

    Best wishes,
    Tobias
    ?
    P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Number format after import from Excel’ is closed to new replies.