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.


Is this what you expect to do?

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


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.