I
Imi
Hi
I have a SAP generated xls file with full of data like this: 23e34, 211e3,
34e344, 33e21 in the cells.
When I open this file in Excel 2007 it realize these cells should be in
Scientific format and set it. But it should not, once it set the wrong format
I cannot set back to TEXT format.
We have checked all the possible settings on the SAP side and no result.
How can I get Excel 2007 not to convert the cell format? How can I turn off
autoformat?
If I import the file over "Text file import" function it is good because I
can tell the program to set the format to text but it is a little more steps
than in the previouse versions and users don't like tis solution
Thanks in advance!
imi
I have a SAP generated xls file with full of data like this: 23e34, 211e3,
34e344, 33e21 in the cells.
When I open this file in Excel 2007 it realize these cells should be in
Scientific format and set it. But it should not, once it set the wrong format
I cannot set back to TEXT format.
We have checked all the possible settings on the SAP side and no result.
How can I get Excel 2007 not to convert the cell format? How can I turn off
autoformat?
If I import the file over "Text file import" function it is good because I
can tell the program to set the format to text but it is a little more steps
than in the previouse versions and users don't like tis solution
Thanks in advance!
imi