| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
editing a cell with time
Hello all,
I ran into a problem with my spreadsheet, can anybody help? I have a cell that reads time as follows "01:23p". I'm in desperate need to edit the cell by adding a space before the letter "p" and add the letter "m" after the letter "p". Is there a way to complete this task. I appreciate your response. Thank you -- smile |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
editing a cell with time
Use worksheet menu Edit - Replace
highlight celss or columns that need replacement from: p to: pm (put a space before the P in the to box) "israel" wrote: Hello all, I ran into a problem with my spreadsheet, can anybody help? I have a cell that reads time as follows "01:23p". I'm in desperate need to edit the cell by adding a space before the letter "p" and add the letter "m" after the letter "p". Is there a way to complete this task. I appreciate your response. Thank you -- smile |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
editing a cell with time
Hi, try Ctrl + H Replace wath : p Replace with :(space)pm Click replace or replace all israel;375180 Wrote: Hello all, I ran into a problem with my spreadsheet, can anybody help? I have a cell that reads time as follows "01:23p". I'm in desperate need to edit the cell by adding a space before the letter "p" and add the letter "m" after the letter "p". Is there a way to complete this task. I appreciate your response. Thank you -- smile -- Pecoflyer Cheers - ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=105004 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
editing a cell with time
Use Edit | Find & Replace?
Find: p <with no leading space Replace: PM <with a leading space best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "israel" wrote in message ... Hello all, I ran into a problem with my spreadsheet, can anybody help? I have a cell that reads time as follows "01:23p". I'm in desperate need to edit the cell by adding a space before the letter "p" and add the letter "m" after the letter "p". Is there a way to complete this task. I appreciate your response. Thank you -- smile |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tracking time editing spreadsheet | Excel Discussion (Misc queries) | |||
| Editing a workbook at the same time | Excel Discussion (Misc queries) | |||
| More that 1 person editing at a time? | Excel Discussion (Misc queries) | |||
| Editing the same file from two computers at the same time | Setting up and Configuration of Excel | |||
| Set the time and date for editing a cell | Excel Worksheet Functions | |||
Linear Mode
