double quotation marked
 

hello community

can community kindly explain to me..

when I do a File Save As....a worksheet with data...as a text(tab delimiter
format), some of the number format has a double quote and some do not have ?

thanks community for the help


oldLearner57

double quotation marked
 

Most likely the numbers showing up in the .txt file are formatted as text and
not as numbers in the Excel worksheet. To be certain, examples of the
numbers with double quotes enclosing them would be nice.

"tikchye_oldLearner57" wrote:

hello community

can community kindly explain to me..

when I do a File Save As....a worksheet with data...as a text(tab delimiter
format), some of the number format has a double quote and some do not have ?

thanks community for the help


oldLearner57

double quotation marked
 

thanks JLatham for the info :)
--
oldLearner57


"JLatham" wrote:

Most likely the numbers showing up in the .txt file are formatted as text and
not as numbers in the Excel worksheet. To be certain, examples of the
numbers with double quotes enclosing them would be nice.

"tikchye_oldLearner57" wrote:

hello community

can community kindly explain to me..

when I do a File Save As....a worksheet with data...as a text(tab delimiter
format), some of the number format has a double quote and some do not have ?

thanks community for the help


oldLearner57