2 replies
Hello Warriors,

I have a spreadsheet with 60,000 rows in text format. How do I change them all to a number format?

Sam
#data #excel #question
  • Profile picture of the author jminkler
    Originally Posted by samcarson View Post

    Hello Warriors,

    I have a spreadsheet with 60,000 rows in text format. How do I change them all to a number format?

    Sam
    Right click change formatting?
    {{ DiscussionBoard.errors[2125877].message }}
  • Profile picture of the author Spastabetic
    You don't have to do this individually, you can select a whole column by clicking the column header like the A,B,C etc. Click on this column header, it should be highlighted and then do the formatting.

    Be careful with changing formatting as sometimes cells contain a space or other strange characters that won't allow the change to number format.
    {{ DiscussionBoard.errors[4628219].message }}

Trending Topics