Text to Numeric format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

SORRY if this is duplicate.
I am importing dates from another application and they come in as text.
(unable to change that).
Now I want to change the format to dates. The format cell option does not
work. BUT if I press F2 on the cell and then enter, it changes it to a date
format. How can I do thsi without having to press F2 in each cell ?????????
 
Hi
try:
- copy an empty cell
- select your imported data
- Goto 'Edit - Paste Special' and choose 'Add'

--
Regards
Frank Kabel
Frankfurt, Germany

Joe said:
SORRY if this is duplicate.
I am importing dates from another application and they come in as text.
(unable to change that).
Now I want to change the format to dates. The format cell option does not
work. BUT if I press F2 on the cell and then enter, it changes it to a date
format. How can I do thsi without having to press F2 in each cell
Click to expand...
?????????
 
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

Date Formating Problem 1
Stop XL from changing format? 1
Format changes from "General" to "Text" 2
Format of cell 1
Formatting numbers as text 1
Formula not reading date format 3
Resetting cell format from TEXT to NUMERIC and DATE 2
text format doesn't work properly 4

Back
Top