Excel 2007 Format issue, colons being substituted for decimals.

C

Caoimhin

We are upgrading our Office version to 2007 and have come across an
interesting problem. We use SAP and download transactional data from SAP to
Excel for further analysis.

In Excel 2003, negative numbers in the display on SAP display as "2,500.00-"
export to Excel as a number (or general) "-2500.00".

In Excel 2007, negative numbers in the display on SAP display as "2,500.00-"
export to Excel as text "-2500:00". I cannot even get these to reformat using
a custom format due to the colon and text status. There is no way to set or
adjust the export options in SAP and it happens through an API call and the
worksheet just pops open with the data in it.

Any help would be appreciated.

I checked all my language and regional settings in Excel 2007 and they are
all set to US and English. I am not sure where to look.
 
S

Sean Timmons

A quick workaround would be to highlight the column and use Find/Replace.

Find : replace with .
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Office Button Missing - Cannot Save 13
SAP Excel 2007 Inplace Can't Save workbook 0
exporting from SAP to Excel 0
SAP to Excel 2007 download format error 0
Mail Merge - displaying a conditional number of decimals 5
Anchor issue with inserting a shape for letterhead 1
Export SAP to Excel 97 Ok, Excel 2003 Error 0

Top