Convert text numbers to number format

  • Thread starter Thread starter montagu
  • Start date Start date
M

montagu

I have received a file that has a date column. However, the column is
reading as text. I need to change the column so that the date reads as
a number format. Any ideas?
 
Right click and reformat as you want then click on cell and press F2 an
enter to refresh data that should do the tric
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Columns formatted As Dates Are Exported as a Number to Text 1
Formatting Text to Numbers for Dates 2
Formatting Text to Numbers for Dates 1
Which is the best MBOX Converter Tool different formats conversion? 4
Formatting Dates from Text to Numbers 2
Convert Numbers stored as Text to Numbers 2
Convert dates stored as text 2
Numbers showing Up Centered in Cell ? 1

Back
Top