That did work for some except I have numbers like '01.002.50.001 for part
numbers and it did not work for those. Any other ideas?

"Joe User" wrote:

"Candida" wrote:
Please advise how I can convert a number that
comes over as '40593 from our Italian firm. How
do I take the ' off of the number.

In Excel 2003, select the cells, click on Data Text to Columns. In this
case, you can breeze through the wizard by clicking Next Next Finish.