Removing commas from numbers

Question

Level 1

0 points

Removing commas from numbers

his has a couple of items in it....

In Numbers, I formatted a phone number column imported from a Text file, but it put in commas, like the phone is a number: 4157933161 is 4,157,933,161. Can I get rid of those commas?

Also, I couldn't import a .txt file (a mailing list from Experian) into Numbers. When I did open the file with Numbers, Numbers put it all in 1 cell - yikes. So I had to go back to my old pc, import the .txt file (easily...) and then take that .xls file and load it on my MAC in Numbers - good golly you have got to be kidding. What am I missing. How do I import a .txt file (it actually is comma seperated but marked as an .txt file - MS Excel had no problem)

This has to do with printing Pages or say pages from the Web. Can you print just a selection of say a Pages doc. Say I select /highlight one paragraph of a 50 page document and want to just print that, on MS in the Print page there is a box "selection" which commands the printer to only print what you selected/highlighted. Customer Care at Apple said he did not know of anyway to do this...yikes again.

iMac 20 inch, Mac OS X (10.5.5), Changed from a PC

Posted on Oct 21, 2008 2:39 PM

Reply

Answer 1

Ric Donato

Level 4

1,129 points

Oct 21, 2008 3:54 PM in response to DIRINGER

Hi DIRIMGER,
Welcome to Numbers discussions.

Take the imported text file into Text Edit (set as plain text, this removes all extraneous formating) then import that into Numbers, finally formate the cells as phone numbers.

There's nothing in error the way Numbers imported the text file. What happened is the import results are not what you expected; doesn't mean anything is wrong. Numbers imports differently than Excel that's all.

Note: You don't have a MAC, Media Access Control, you have a Mac as in Macintosh.

Enough with the "Yikes" already.

These forums are end users the same as yourself, we're not Apple employees doing tech support.

Again welcome to Numbers discussions, have fun here.

Cordially,

RicD

Reply

Answer 2

KOENIG Yvan

Level 8

41,819 points

Oct 22, 2008 2:21 AM in response to DIRINGER

In Numbers, I formatted a phone number column imported from a Text file, but it put in commas, like the phone is a number: 4157933161 is 4,157,933,161. Can I get rid of those commas?

Find / Replace is your friend.
Find "," Replace by nothing.

Also, I couldn't import a .txt file (a mailing list from Experian) into Numbers. When I did open the file with Numbers, Numbers put it all in 1 cell - yikes. So I had to go back to my old pc, import the .txt file (easily...) and then take that .xls file and load it on my MAC in Numbers - good golly you have got to be kidding. What am I missing. How do I import a .txt file (it actually is comma seperated but marked as an .txt file - MS Excel had no problem)

Comma Separated Values files are correctly treated if their name extension is .csv.

This has to do with printing Pages or say pages from the Web. Can you print just a selection of say a Pages doc. Say I select /highlight one paragraph of a 50 page document and want to just print that, on MS in the Print page there is a box "selection" which commands the printer to only print what you selected/highlighted. Customer Care at Apple said he did not know of anyway to do this...yikes again.

He is perfectly right. There is no such feature.
As we may print a given range of pages it's not a true problem.
We may insert temporary page breaks to do the trick.

And of course, if you prefer MS you may stay with it !

Yvan KOENIG (from FRANCE mercredi 22 octobre 2008 11:20:29)

Reply