Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

German to American Decimal Conversion

Status
Not open for further replies.

jsaliers

Programmer
Joined
Jan 23, 2003
Messages
129
Location
US
Quick question for y'all. My company is getting data from a german company. The problem is, they use commas instead of decimal points. Does anybody know of software or a method to convert a page of Excel data from German format into a standard American format?

Thanks in advance,

Jon
 
Normally, if the cells are formatted as number without specific details it should be ok. Text is different but you try a macro.
You can change you number handling in Control Panel before opening it.
Of course, that is not handy if you receive a lot of data from both sides.
The . and , issue is an annoying one, but it is not a standard. If the answer is here, mark it, others can benefit from it too.
Free Tip: The F1 Key does NOT destroy your PC!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top