Texto a numeros

buen dia. estoy leyendo un archivo .csv cuyo primer campo son numeros entre el 1 y el 250, aunque no están todos, pero vienen indicados como "001, 004, 005, 012, etc. y necesito convertir esos numeros que tienen formato de texto a formato de numeros, o sea eliminar los ceros iniciales de cada número. Gracias

This happens more or less automatically if you perform a mathematical operation.

or

Is this what you expect to do?

Here are some other ways Trim leading zeros from numbers stored as text

Regards,
Steve

thank you Steve. The one with " round" works perfect. I was trying with "absolute" and didn´t work.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.