bdc excel prob

[Former Member]

hi gurus, i am creating a flat file in excel sheet for bdc. how to put the values like '001' or '010' in excel sheet, as the first 0 is getting rounded off and it is appearing like '1' or '10' . pls help me out.

[Former Member]

Hi,

I used to use apostrophe at the begining: '001 - this makes cell to be interpreted as text, not a number.

I think this should help you,

Regards,

MC

[Former Member]

Hey Roy,

If you want leading zeros in front of 1, 2 etc. then change the format of the columns or cell to text.

Suppose you want to have some leading zeros for column A in the excel, then right click on the column and select the format cells option. Once you are done with that, select 'TEXT' under 'NUMBER' tab. It will solve your problem. The same thing you can apply for whole of the excel sheet. I also tried doing the same.

Revert back if still facing some prob.

Cheers

VJ

[Former Member]

Hi,

You just right click on the column ,Goto Format Cells,then Click on text and press ok,then you will have all the leading zeroes com,ing in before the Numbers.

Regards,

Rahul