european

Hi I have a spreadsheet where data for three columns from a certain row is in "European" format. So, $5.50 (fiver dollars and fifty cents), is down as $5,50 i.e with a comma instead of a full stop. This is causing errors with some calculations, as Excel can't handle 5,50/100, for example...

For Inventory, manufacturers barcodes are being imported or scanned into Excel, problem is that Euro barcodes bring in sometimes "=" as a prefix to the numerical value skewing what Excel reads, converting the number sequence into a "formula". I want to understand and convey to Excel that it is...

For inventory purposes, cells are viewing European manufacturer barcode as formula. What I need is for the prefixes not to be seen as anything more than just symbols. What suggestions can be posed. Please make me aware if more information is needed to help solve this. Thanks

Excel 2010 Using Windows Operating System Hi, I'm an America trying to convert the values I have in 1 spreadsheet to a European number format. The American format seperates thousands with "," and decimals with ".". The European system is the opposite seperating thousand figures with a "."...