How to remove decimals from tab delimited files Excel -

Thank you for taking the time to read your question.

My Excel file, cells are round for two decimals, but when I save a tab in a delimited file format, some fields are equal to several decades, even if they appear in Excel cells Do not give it.

Was hoping someone could help me.

I am using tab delimited files which are uploaded to mysql

Please note that I am not a programmer! Thanks a lot!

The actual value in the cell is not round, but only 2 is the decimal. If you export, the format is ignored and the actual value is exported. To avoid that, I suggest adding cell-round formulas.

  = round (your value; 2)  

2 = number of decimals

Your price may be other cells or calculations .

Regards