convert number as text to numeric value

Asked by Michael Bellamy

Importing list of numbers into spreadsheet from csv file puts them in as text not numbers. How do I get them back to numerics?

Question information

English Edit question
Ubuntu Edit question
No assignee Edit question
Solved by:
Tony Pursell
Last query:
Last reply:
Revision history for this message
Best Tony Pursell (ajpursell) said :

Hi Michael

In the Text Import dialogue you do have the opportunity to give a column type that is different from Standard.

If you have already imported the data, highlight the column, go Format > Cells and specify the number type under the Numbers tab.


PS If this answers your question, please mark it as Solved

Revision history for this message
Michael Bellamy (mike-clare-bellamy) said :

Thanks Tony Pursell, that solved my question.