Insert a number a number in column

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

Hi

If you put this formula in a cell beside the incorrect column and copy it
down through the column it should be OK

=VALUE(1&E4) where E4 is the cell containing the wrong data.


--
Sharon


"webfort" wrote:

>
> 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=543233
>
>