Paste to excel 97 from Navision Financials

[Niklas Banck]

Hi!

I have a customer with a little problem.
When she paste data from a report in Navision Financial 2.x to Excel 97
there´s a problem with the numbers. Cell format is not set to numbers in
these cells where there is a space indicating thousand value ex. 10 400,
this is treated as text in excel. If I manually remove the space and click
with the mouse in the top of excel ("inputfield") everything is ok. I tried a
macro that removed all spaces, but without result.... What can be wrong, any
idea what I can try?

 

[Bob Buckland ?:-\)]

Hi Niklas,

You may also want to post this in the MS Navision newsgroup,
news://msnews.microsoft.com/microsoft.public.navision
(if through your browser use the Community link on
http://microsoft.com/businesssolutions/navision

as well as in one of the MS Excel newsgroups such as
news://msnews.microsoft.com/microsoft.public.excel

======
Hi!

I have a customer with a little problem.
When she paste data from a report in Navision Financial 2.x to Excel 97
there´s a problem with the numbers. Cell format is not set to numbers in
these cells where there is a space indicating thousand value ex. 10 400,
this is treated as text in excel. If I manually remove the space and click
with the mouse in the top of excel ("inputfield") everything is ok. I tried a
macro that removed all spaces, but without result.... What can be wrong, any
idea what I can try?
--
Best Regards

Niklas Banck>>
--
I hope this helps you,

Bob Buckland ?
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*

Office 2003 explained
http://microsoft.com/uk/office/editions.asp