| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find / replace in excel 2003
I have a column formatted m/yy for the date 2/08. Tried to replace 2/08 with
8/08 and excel couldn't find 2/08 - I realized that the cell actually contained the date 2/8/2008 and I needed to use that to find/replace. Is there some setting I need to change so the cell actually contains 2/08? Thanks for your time dp |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Find / replace in excel 2003
You would need to precede the entry with an apostrophe or preformat the
cells as text, Excel cannot accept 8/08 as a date, it will try to help you convert it to a regular date -- Regards, Peo Sjoblom "dp" wrote in message ... I have a column formatted m/yy for the date 2/08. Tried to replace 2/08 with 8/08 and excel couldn't find 2/08 - I realized that the cell actually contained the date 2/8/2008 and I needed to use that to find/replace. Is there some setting I need to change so the cell actually contains 2/08? Thanks for your time dp |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Find / replace in excel 2003
Thank you.
"Peo Sjoblom" wrote: You would need to precede the entry with an apostrophe or preformat the cells as text, Excel cannot accept 8/08 as a date, it will try to help you convert it to a regular date -- Regards, Peo Sjoblom "dp" wrote in message ... I have a column formatted m/yy for the date 2/08. Tried to replace 2/08 with 8/08 and excel couldn't find 2/08 - I realized that the cell actually contained the date 2/8/2008 and I needed to use that to find/replace. Is there some setting I need to change so the cell actually contains 2/08? Thanks for your time dp |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i use the find and replace in excel 2003 | New Users to Excel | |||
| Excel 2003 Find and Replace | New Users to Excel | |||
| Find & Replace Option in Excel 2003 | Setting up and Configuration of Excel | |||
| find and replace links in Excel 2003 | Excel Worksheet Functions | |||
| Find and replace Excel, Office pro 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
