double quotation marked

G

Guest

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
 
G

Guest

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.
 
G

Guest

thanks JLatham for the info :)
--
oldLearner57


JLatham said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

create a list base on another worksheet 2
Text Qualifiers 1
Convert excel (.xls) to tab delimited (.txt) without double quotat 3
Converting Numbers from Excel to TXT files 2
Quotation Marks as Text 2
Excel CSV file: How to preserve double quotation mark on Unix ftp? 2
quotation marks in .txt files 1
Crunching for Covid-19 3

Top