| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I automatically replace data when importing a text file? | New Users to Excel | |||
| can i convert numbers to text automatically | Excel Worksheet Functions | |||
| How can I sort a group of numbers automatically as data is entere | Excel Worksheet Functions | |||
| automatically adjust numbers in a column when data is deleted | Excel Worksheet Functions | |||
| Negative numbers turn positive automatically on data entry | Excel Discussion (Misc queries) | |||
Threaded Mode
