We are running SAP version 640, and Excel 2007. Since upgrading to Excel 2007 when exporting data (not saving to file) the data is in scientific format in excel.
Any help would be appreciated
JMuscat
thanks for the reply, i have exported from pronto into access, to run a catt i have imported the data into excel.
after numerous searching i have have the answer to the problem, the delimiter was an comma, this was causing the parenthesis.
I have replaced these and now all is ok
many thanks
I have a large amnount of data exported from a program called pronto. When I import this into SAP from Excel I get an " in front and at the end of the text string.
I have tried find/replace to exclude this but still happens.
Any ideas
Basically the cells contain random numbers anything from 856 to 1245634.
In some instances, not all, I need to add an extra zero at the front of the number. The only common factor would be that all the numbers reside in column A.
Many thanks
waynerenaud
Many thanks for your quick response, but ideally I would like a macro so that I am able to run this on various spreadsheets.
A star for your time
I am wanting to create a macro that will add a zero to the front of certain cell numbers.
I cannot seem to work it out.
Say column A has 856, I need a macro to change it to 0856, but also use the macro on other values in other cells.
Any ideas
I am wanting to create a macro that will add a zero to the front of certain cell numbers.
I cannot seem to work it out.
Say column A has 856, I need a macro to change it to 0856, but also use the macro on other values in other cells.
Any ideas
I want a macro to find a specific word say in column A,then pick up the amount of the next column (b) of the same row and return the amount to another column say H.
The problem is that the place where I want the amount to go will always change, but would be at the next available blank row in...
I am recording and writing a macro to format an imported data file into excel for users.
What I am having trouble is, I need code to loop down a rows containing data, find the first blank row and then delete the next ten rows.
Can someone help me with the code.
jmuscat
Open the text file in Excel and follow the wizard choosing delimited and what type of delimiter i.e. space.
If the list of names appears in one column, highlight the column and from the main menu select Text to Columns.
Copy into existing template.
Hope this helps.
JMuscat
I have a large spreadsheet of data imported from SAP.
I am now attempting to do a vlookup against this data with another spreadsheet. The problem is my customer number column is reading as Text, so that I cannot successly sort in proper ascending order, ergo my vlookup is not working correctly...
This is an issue that some of my users were experiencing. At some stage they had changed/formatted the style, and placed a tick in the checkbox, automatically update (Format => Style => Modify). When this box was unchecked the problem disappeared.
Hope this helps.
I am still a novice with vba, and I have created an excel workbox with macros to automate some functions. Now I would like to add code to the macro, so that when the workbox is opened, it will execute the macro instead of having a macro button on the spreadsheet. Could someone help me with the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.