Skip to Content
0
Former Member
Aug 02, 2005 at 03:22 PM

Format for excel cell after downloading .....

53 Views

Hi all,

yet another frustrating thing with excel.. kindly shed some light on this ...

situation is : in one of our R/3 system i'm downloading the ALV report to excel and one of the value fields are mis-aligned like few numbers are right-aligned and few others are left-aligned.... coincidentally all left-aligned numbers are < 1 (like 0.3 ....). user setting for point notation is 'DOT' for thousand separator.

In other R/3 system (our test server) this situation is not happening...all 'values' are fine i.e. right-aligned....

Should be to do some thing with system setting but not able to point out exactly.... spent lots of time in debugging standard xcel download thing...that's driving me crazy.....

kindly help me out....

Thanks in advance