Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formating time when pasting from PDF to excel?
Not sure if I can explain this right but I am taking data from a PDF
file and putting it into excel. I am taking data that is in the format hours, minutes, seconds such as 1 hour 20 minutes 10 seconds or 1:20:10. I have the cells formated to [h]:mm:ss When I paste the data into excel it shows in both the cell and formula bar as 00:56:39. What I do next is highlight the cell, left click the formula bar to put the curser up there and then press enter. The data will change in the cell to 0:56:39 and in the formula bar it changes to 12:56:39 AM. What I want to do is have it change to the format 12:56:39 AM with out having to click each cell one at a time. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formating time when pasting from PDF to excel?
Try selecting the cells and DataText to ColumnsFinish
This may do the trick. Alternative........... Format an empty cell to [h]:mm:ss Copy that cell then select your cells and in place Paste SpecialAddOKEsc Gord Dibben MS Excel MVP On Thu, 04 Oct 2007 17:13:25 -0700, NuclearJACK wrote: Not sure if I can explain this right but I am taking data from a PDF file and putting it into excel. I am taking data that is in the format hours, minutes, seconds such as 1 hour 20 minutes 10 seconds or 1:20:10. I have the cells formated to [h]:mm:ss When I paste the data into excel it shows in both the cell and formula bar as 00:56:39. What I do next is highlight the cell, left click the formula bar to put the curser up there and then press enter. The data will change in the cell to 0:56:39 and in the formula bar it changes to 12:56:39 AM. What I want to do is have it change to the format 12:56:39 AM with out having to click each cell one at a time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: How to retain default formating after pasting ? | Excel Discussion (Misc queries) | |||
Copying and pasting table info and cell formating in one hit | Excel Discussion (Misc queries) | |||
time stamp on MULTIPLE cells by PASTING | Excel Discussion (Misc queries) | |||
TIME FORMATING | Excel Discussion (Misc queries) | |||
Time Formating | Excel Worksheet Functions |