number
 

the error is :"the number in this cell is formatted as text or preceded by an
astrophe", It means we must convert it to number and we can do, but I don't
want this error appear in other excel file again.How can I do?

number
 

This can be easily avoided. Before making any entries into a worksheet or
template, make sure the cells to be used for numerical input have been
pre-formatted to General, not Text.
--
Gary''s Student - gsnu201001


"hungayun" wrote:

the error is :"the number in this cell is formatted as text or preceded by an
astrophe", It means we must convert it to number and we can do, but I don't
want this error appear in other excel file again.How can I do?