Material master source file error !

[sachin_soni]

HI all !

When i open my tab delimited file in excel (so that it is easily editable), i face a problem and that is values like '00204' OR '0001' get converted to 204 and 1 respectively and that causes error as such values are not what that particular field expects.

if somebody cud give me a permanent soln for that ,that wud be grt

regards

sachin soni

[Former Member]

maintain that column as a TEXT , then it will not remove ZEROS , u cannt do any thing in SAP , its totally with EXCEL.

Regards

Prabhu

[sachin_soni]

prabhu thx 4 prompt ans , buddy but the problem is even after maintaining it as text when i open again in excel ,the zeeroes are gone again.

regards,

sachin

[Former Member]

download the file in text format.

[sachin_soni]

utsah i didnt get u ,download frm where??

[Former Member]

Hi,

try this,

Sent that field value to some character data type variable and then download it.

Regards,

Suresh

[sachin_soni]

hi suresh i think ppl r nt getting me , i have a source file .which is to be uploaded and not in the system yet.i need to upload it and not download it and there is no question of transferring it to a char type variable at all.

thanks

sachin

[sachin_soni]

anybody????????????????????????????

[Former Member]

Hey,

First open an excel sheet and format all the cell contents as text. Later copy the contents of your tab delimited file and paste it on that excel sheet.

Thanks,

Surya