Hi Candida

But those values are Text. They cannot be numeric.
If you used the suggestion by Joe, Data Text to columns, then that does
work, the only difference being your numerics end up right justified,
whilst the other Text values are right justified

If it is the presence of the single quote that is giving you the
problem, but you still want everything to remain left justified, then
you could use another column and enter
=SUBSTITUE(A1,"'","")
and copy down.
Then mark the whole of the new columnCopyPaste SpecialValues
and your data will not have the leading '

--
Regards
Roger Govier

Candida wrote:
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.