Currently Being ModeratedMar 21, 2013 11:01 AM (in response to gregmiata)
I think I would make a new table and format the whoe table as text (so no data conversion happen), then open the CSV file in a text editor, select all, copy, then paste into the Numbers table that is formatted as text.
Currently Being ModeratedMar 21, 2013 11:24 AM (in response to Wayne Contello)
Thank you and pardon my ignorance but when I do that it puts all of the data into one column per row. How do I then separate it out to different columns again?
Currently Being ModeratedMar 21, 2013 12:04 PM (in response to gregmiata)
My bad... I think csv only IMPORTs properly (not by paste). To paste you will also have to replace all "," (commas) with tabs.
Currently Being ModeratedMar 21, 2013 6:47 PM (in response to gregmiata)
There is no such thing as a Time-Only cell format in Numbers. But you can create a text string from the Date & Time.
Let's say your date & time cells are in column B and are formatted to show only the time.
In another column you can use a formula =B & ""
Or, in another table it would be =Table 1::B & ""
This will make the time into a text string.