Format problem

  • Thread starter Thread starter Manos
  • Start date Start date
M

Manos

Dear all,

i export data from a program of BAAN which export data
from a line machine production

the problem is that i can see the numbers in excel which
formated to general option and when i am trying to make a
sum i don not have a result
probably it can not recognise the characters....

i tried to change them to number format but still i have
the same problem

There is any possibility to know what is going on?

Thanks in advance
Manos
 
Hi Manos
try the following
- select an empty cell and cop this cell (CTRL+C)
- now select the column with your numbers
- goto 'Edit - Paste Special' and choose the action 'Add'

tyr the SUM function again
 
Back
Top