Power Query is ADDING in leading zeros when convert to text

[sbawnh]

I have a column with both numbers 1-99 and a few alphanumerics like U08.

Import throws an error because "U" isn't a number.
However, all my numbers now have leading zeros, 3 is now 003.

Can I convert to text while maintaining the original numbers?

 

[Norie]

Where are you importing the data from?

 

[sbawnh]

Nevermind!

How can I mark this thread as solved or delete it?

 

[sandy666]

import all as is whitout changing format
remove "U"
set column format to whole number

edit:
the best way is post a link to the shared excel file with representative example

edit2:
simply post word: Solved (and solution if any)
that's all