View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Qaiser96 Qaiser96 is offline
external usenet poster
 
Posts: 4
Default 2007 - automatically changes text data to numbers

I am currently using Excel 2007.

When I download / transfer data from SAP into Excel 2007, it automatically
changes the text data into number data. For example, it removes zero ' 0'
from the beginning of the data. i.e. if the data is '007', it would become as
'7' when it is transferred into Excel.

I was previously using Excel 2003 and I was not having this trouble.

Can anyone please advice.

Regards.

Qaiser