Problema al Exportar excel - Excel Export Issue

[Former Member]

Hola.

Cuando exporto información al Excel, no me reconoce la columna o columas numéricas, no puedo agregar o quitar decimales. la Versión de Excel es 2010 y el SAP es el B1 Actualizado a la fecha.

Gracias

Hi.

When I export info to Excel, I cant add or remove decimals from the numeric fields. The Excel versión is 2010 and SAP is B1.

Thanks in advice

[ameet_desai]

Hi,

This could be happening because the numbers are entered in text, if you see a small green triangle on the upper left hand corner of the cell just before the number, then it is a text field.

Select the entire column of the numeric field you want to change.

Click on Format and select Format Cells.

In the Number Tab Select Number, Enter the Decimal Places. Tick the 1000 separator box if you want commas in the numbers.

Thank You.
Regards,