| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I "change to" for multiple cells ie change all 07's to 08'
I have multiple wrong dates on a worksheet and can't remember how to change
all of them at once to the correct date. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I "change to" for multiple cells ie change all 07's to 08'
Well if the wrong dates are all the same you can find and replace... I'd have
to know more about what the wrong dates are and what you want to change them too. "old timer" wrote: I have multiple wrong dates on a worksheet and can't remember how to change all of them at once to the correct date. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I "change to" for multiple cells ie change all 07's to 08'
Hi Young Man
Go to Edit "Find/Replace Regards Cimjet "old timer" <old wrote in message ... I have multiple wrong dates on a worksheet and can't remember how to change all of them at once to the correct date. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I auto transform sets of data? (change "female" to "f") | Excel Discussion (Misc queries) | |||
| How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| How to change "automax" to "autosum"? (probablyl wrong terminology) | Excel Discussion (Misc queries) | |||
| =IF(D13="PAID","YES","NO") Can I change fonts colour | Excel Discussion (Misc queries) | |||
Hybrid Mode
