View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
mepetey mepetey is offline
external usenet poster
 
Posts: 19
Default help for applying formula

You literally want to add "=" into each of the cells? or do you want the
calculation to run?

"Raan" wrote in message
...
Hi All,


3*2 3*3
3*2 3*4
3*4 3*4
3*2 3*2
3*5 3*5
3*4 3*4
3*4 3*4
3*5 3*5
3*5 3*5
3*4 3*4
3*4 3*4
3*4 3*4
3*2 3*2
3*3 3*3


I have following kind of data i want to convert the above column into
following , how can i do that

=3*2 =3*3
=3*2 =3*4
=3*4 =3*4
=3*2 =3*2
=3*5 =3*5
=3*4 =3*4
=3*4 =3*4
=3*5 =3*5
=3*5 =3*5
=3*4 =3*4
=3*4 =3*4
=3*4 =3*4
=3*2 =3*2
=3*3 =3*3

Can i do it using the help of macro ?

Regards,
Raan