Copy numeric data from form, paste into Excel.

rossirossi Member Posts: 36
Hi

I have problem pasting numeric data into Excel. Excel will not take the Navision Digit Grouping Symbol as the gouping symbol set in Regional and Language Options, thereby threating the number as text.

Anybody who know how to overcome this problem?

Rossi

Comments

  • mart1n0mart1n0 Member Posts: 123
    Probably your Navision server has other "Regional Settings" than your computer.

    Change the regional settings of your computer so they match the ones of the server (or the other way around but then you need access to the server) and try to paste again to Excel to see what happens.

    If your pc has the same digit grouping symbol setup now, it should paste as a number.
  • andrejsmandrejsm Member Posts: 122
    Server "Regional Settings" have no relations to user computer "Regional settings". These are two different things!
    You are using wrong Digit grouping symbol in your regianal settings! It should be just "Space"!
    Andrejs Muraskins
  • rossirossi Member Posts: 36
    Hi

    Thanks...space AND restarting the client solved this problem..

    Rossi
Sign In or Register to comment.