topic Re: bdc excel prob in Application Development and Automation Discussions

bdc excel prob

Former Member — Fri, 23 Apr 2010 22:06:19 GMT

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.

Re: bdc excel prob

Former Member — Sat, 24 Apr 2010 00:35:06 GMT

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,

Re: bdc excel prob

Former Member — Mon, 26 Apr 2010 04:27:12 GMT

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

Re: bdc excel prob

Former Member — Mon, 26 Apr 2010 04:41:53 GMT

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