View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lori Lori is offline
external usenet poster
 
Posts: 272
Default 100*50 to =100*50

A further option...

- Check Tools Options Transition Formula Entry
- Select column and choose Data Text to Columns Finish

"Mortir" wrote:

I have an entire column written as in example 100*50 (without =),
which of course means that the equation doesnt caltulate... what would
be the easiest way to correctly define the equation as =100*50 that it
would properly calculate itself...