Copying to Excel

JTPro
JTPro Member Posts: 169
edited 2006-08-23 in NAV/Navision Classic Client
Hello all,

My client has a problem with copying columns, that contain numbers (from Navision to Excel). The problem is that Excel shows number with space between digits. Excel treads such numbers as a Text, not as a Number. It makes my client crazy. Is there any method to fix this inconvenience?

Thanks in advance for your answers.

Best regards
Navision Application Version: 4.0SP1
Navision Database Version: 4.0

Answers

  • frede
    frede Member Posts: 80
    Maybe this can help?

    Sheet.Range(coloum + row).NumberFormat := '#.##0';
    Regards,

    Henrik Frederiksen, Denmark
  • Pelle
    Pelle Member Posts: 18
    Open the control panel in the client computer.
    Open the regional settings.
    change the thousands separator to a space.
    Hit OK.

    The standard thousands separator looks like a space, but isn't,
    so Excel doesn't recognise the copied number as a pure number.

    //Pelle

Categories