| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Text to Numeric format
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 ????????? |
|
#2
|
|||
|
|||
|
Hi
try: - copy an empty cell - select your imported data - Goto 'Edit - Paste Special' and choose 'Add' -- Regards Frank Kabel Frankfurt, Germany "Joe" schrieb im Newsbeitrag ... 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 ????????? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pasting data from a website changes text to date | Excel Discussion (Misc queries) | |||
| How do I import XML as text format | Excel Discussion (Misc queries) | |||
| Import comma delimited text | Excel Discussion (Misc queries) | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
| cut and paste format problem | Excel Discussion (Misc queries) | |||
Linear Mode
