View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rechie Rechie is offline
external usenet poster
 
Posts: 57
Default Calculation by inserting = sign at the start of equaton

I have column in a sheet that contains below:
8+4+8
8+4+4
4+8+4
4+8+2
Equation might be text as I exported this from other application.
I have to insert = sign at the start of the equation to calculate. e.g =8+4+8
and press enter to get the results of 20. How can I get the results in a
quicker way? I have thousand lines in the file.
Thanks