New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

saving .txt with Numbers


Post Reply New Thread Subscribe

 
Thread Tools
Snorkle

 
Member Since: Jul 06, 2010
Posts: 3
Snorkle is on a distinguished road

Snorkle is offline
Does anyone know how to save a file as .txt with numbers?

It won't let me save .txt w/o adding .numbers, so that it looks like filename.txt.numbers

I can convert to a filename.xls, but then can't convert that to filename.txt and be able to open it with a text editor.
QUOTE Thanks
chscag

 
chscag's Avatar
 
Member Since: Jan 23, 2008
Location: Fort Worth, Texas
Posts: 38,894
chscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond repute
Mac Specs: 27" iMac i5, 3.2 GHz, iPad 3, iPhone 5c, 3 iPods, OS X Mavericks

chscag is online now
I don't understand why you need or would want to save a spreadsheet file as text? You would lose all formatting if you did and any kind of graphing would likewise be lost.

If there are parts of the Numbers or Excel file you want to export to text, you can always do that with copy and paste. But again, you would have to consider the formatting.

Regards.
QUOTE Thanks
Snorkle

 
Member Since: Jul 06, 2010
Posts: 3
Snorkle is on a distinguished road

Snorkle is offline
I am working with a large data set and want to delete two entries from every line. If i load it into a spreadsheet I can easily delete the two columns then save it as a text file and open it with the program that i am using to manipulate the data.
QUOTE Thanks
technologist

 
Member Since: Mar 30, 2004
Location: USA
Posts: 4,744
technologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond reputetechnologist has a reputation beyond repute
Mac Specs: 12" Apple PowerBook G4 (1.5GHz)

technologist is offline
Numbers can export tables as CSV files, which are text-based.

It's hard to translate a table of values, with rows and columns, into a plain old .txt file.
QUOTE Thanks
chas_m

 
chas_m's Avatar
 
Member Since: Jan 22, 2010
Location: Victoria, BC
Posts: 16,441
chas_m has a reputation beyond reputechas_m has a reputation beyond reputechas_m has a reputation beyond reputechas_m has a reputation beyond reputechas_m has a reputation beyond reputechas_m has a reputation beyond reputechas_m has a reputation beyond reputechas_m has a reputation beyond reputechas_m has a reputation beyond reputechas_m has a reputation beyond reputechas_m has a reputation beyond repute
Mac Specs: 2009 MBP, Black speakers, Black Benq second monitor, black(ish) iPhone 5s, Black 2012 iPad, etc.

chas_m is offline
File -> Export
QUOTE Thanks
Snorkle

 
Member Since: Jul 06, 2010
Posts: 3
Snorkle is on a distinguished road

Snorkle is offline
thanks for the replies, not working though.

I was trying to avoid DLing and installing excel, but alas that's what I had to resort to. It's just silly that numbers doesn't have this basic function that excel has been doing for ages.
QUOTE Thanks
Aptmunich

 
Aptmunich's Avatar
 
Member Since: Mar 09, 2004
Location: Munich
Posts: 9,075
Aptmunich has a brilliant futureAptmunich has a brilliant futureAptmunich has a brilliant futureAptmunich has a brilliant futureAptmunich has a brilliant futureAptmunich has a brilliant futureAptmunich has a brilliant futureAptmunich has a brilliant futureAptmunich has a brilliant futureAptmunich has a brilliant futureAptmunich has a brilliant future
Mac Specs: Aluminium Macbook 2.4 Ghz 4GB RAM, SSD 24" Samsung Display, iPhone 4, iPad 2

Aptmunich is offline
Copy and the section you want, open Textedit, select "format > make plain text" and paste.

Save to create a .txt.
QUOTE Thanks

Post Reply New Thread Subscribe


« iWork Issue - Unexpectedly Quits | iPages '08 Word Art »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Issue saving .xls in numbers 09 Xanthian OS X - Apps and Games 0 03-28-2010 09:06 AM
Phone numbers disappear in Address Book Juba22 OS X - Apps and Games 0 12-14-2009 08:48 AM
iTunes Track numbers with audible files charliexedd OS X - Apps and Games 1 11-07-2009 02:28 PM
Copying data from email into numbers on iMac Andy and Shell Apple Desktops 0 03-08-2009 05:22 PM
Cutting and Pasting from emails into Numbers Andy and Shell Switcher Hangout 0 03-08-2009 05:20 PM

All times are GMT -4. The time now is 01:56 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?