| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time format
I have copied and pasted some data including times. Some times have a single
digit for the hour and when it pastes into Excel, that first digit comes in as a space not a zero. Because of that, those fields seem to ignore all formatting changes. Is there a trim function for times? -- Oregon Julie |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time format
I usually highlight the cells and then use the menu option Edit - Replace.
Put a space in the FROM: box and nothing TO: box and click REPLACE ALL. Sometimes it is not just a space but some other invisible character. then do the same but highlight on the worksheet the invisible character and type Cntl (to copy) and then go to the replace From box and paste the character into the box using Cntl - V. Then select REPLACE ALL. "JulieB" wrote: I have copied and pasted some data including times. Some times have a single digit for the hour and when it pastes into Excel, that first digit comes in as a space not a zero. Because of that, those fields seem to ignore all formatting changes. Is there a trim function for times? -- Oregon Julie |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time format
It replaces the space between the date and AM/PM. Am I doing something wrong?
-- Oregon Julie "Joel" wrote: I usually highlight the cells and then use the menu option Edit - Replace. Put a space in the FROM: box and nothing TO: box and click REPLACE ALL. Sometimes it is not just a space but some other invisible character. then do the same but highlight on the worksheet the invisible character and type Cntl (to copy) and then go to the replace From box and paste the character into the box using Cntl - V. Then select REPLACE ALL. "JulieB" wrote: I have copied and pasted some data including times. Some times have a single digit for the hour and when it pastes into Excel, that first digit comes in as a space not a zero. Because of that, those fields seem to ignore all formatting changes. Is there a trim function for times? -- Oregon Julie |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time format
Go back and replace "AM" with " AM" (add a space in front) and do the same
with "PM" to " PM" This should fix the problem. "JulieB" wrote: It replaces the space between the date and AM/PM. Am I doing something wrong? -- Oregon Julie "Joel" wrote: I usually highlight the cells and then use the menu option Edit - Replace. Put a space in the FROM: box and nothing TO: box and click REPLACE ALL. Sometimes it is not just a space but some other invisible character. then do the same but highlight on the worksheet the invisible character and type Cntl (to copy) and then go to the replace From box and paste the character into the box using Cntl - V. Then select REPLACE ALL. "JulieB" wrote: I have copied and pasted some data including times. Some times have a single digit for the hour and when it pastes into Excel, that first digit comes in as a space not a zero. Because of that, those fields seem to ignore all formatting changes. Is there a trim function for times? -- Oregon Julie |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time format
Duh....thanks!
-- Oregon Julie "Joel" wrote: Go back and replace "AM" with " AM" (add a space in front) and do the same with "PM" to " PM" This should fix the problem. "JulieB" wrote: It replaces the space between the date and AM/PM. Am I doing something wrong? -- Oregon Julie "Joel" wrote: I usually highlight the cells and then use the menu option Edit - Replace. Put a space in the FROM: box and nothing TO: box and click REPLACE ALL. Sometimes it is not just a space but some other invisible character. then do the same but highlight on the worksheet the invisible character and type Cntl (to copy) and then go to the replace From box and paste the character into the box using Cntl - V. Then select REPLACE ALL. "JulieB" wrote: I have copied and pasted some data including times. Some times have a single digit for the hour and when it pastes into Excel, that first digit comes in as a space not a zero. Because of that, those fields seem to ignore all formatting changes. Is there a trim function for times? -- Oregon Julie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding time in 24 hour format to produce hours in decimal format | Excel Worksheet Functions | |||
| Convert time stored as decimalised number to time format | New Users to Excel | |||
| Custom Cell format to mimic time format | Excel Discussion (Misc queries) | |||
| convert time imported as text to time format for calculations | Excel Worksheet Functions | |||
| Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions | |||
Linear Mode
