Say wrong numbers are in Column H, insert this formula in a helper column:

=VALUE(1&H2)
Drag it down as required!
Then copy the helper column and PasteSpecial/Values into column H.

Regards,
Stefi


€žwebfort€� ezt Ã*rta:


Hi,

I was wondering if any one could help me, I have some data which was
inputted incorrectly and I need to amend it, there seems to be a
pattern, its missing the number 1 before the number eg 31456 should be
131456. There are over 1000 records and would take a long time to do
manually, could anyone help me?

Thanks

Ashley


--
webfort
------------------------------------------------------------------------
webfort's Profile: http://www.excelforum.com/member.php...fo&userid=7964
View this thread: http://www.excelforum.com/showthread...hreadid=543232