empty /blank spaces Navision 2009

milozappa

Hello everybody,

I am importing data from an excel table, in a cross reference, but I need to upload the information with an empty space at the beginning of the number, like this,
' 123 456 466'
In the excel table is written: ' 123 456 789 , but when the data is imported is deleting the empty space, is there a special character to do this?

thanks

EMilio

Slawek_Guzek

Hi

The problem might be caused by the spreadsheet content.

Makes sure the data to import is stored as text, not as numbers.

As a test add somewhere a formula adding up some cells you are trying to import. If the formula won't return an error it means that Excel sees the content as numbers, not as a text.

Try editing your spreadsheet and add an apostrophe and space before each number, so when you press F2 in the cell the number looks like ' 123 456 466, rather than 123456466. That will ensure that the cell content will be treated as text.

If Excel sees the spreadsheet cell content as a number NAV will not see it any different.

Slawek