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

SAP Excel 2007 Inplace Can't Save workbook 0
SAP to Excel 2007 download format error 0
add/subtract dates problem in Excel..... 3
Data exported to excel 2007 changes cell number format to 'general' ? 1
Excel reading pasted values as Scientific Notation 3
Date conversions....Excel thinking too hard? 1
Cell formatting issue 8
Excel 2007 - display negative numbers with minus sign and parenthe 3

Top