Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formating
I have a schedule to take meds three times a day every day every month. How
can I change the name of the month by using the find and replace function or other methods...Thank YOu in advance. Greg Date Time 1-Mar 6:30 am 1-Mar 11:30 pm 1-Mar 4:30 pm 2-Mar 6:30 am 2-Mar 11:30 pm 2-Mar 4:30 pm 3-Mar 3-Mar 3-Mar 4-Mar 4-Mar 4-Mar |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formating
hi again,
i made a mistake in the formula. it should be..... =DATE(YEAR(A2),MONTH(A2)+1,DAY(A2)) sorry FSt1 "FSt1" wrote: hi, if your date data in formated as text, the find and replace all will work. if your date data is fromated as date then try something like this in a blank column (in your example - column C)...... =DATE(YEAR(A2),MONTH(A)+1,DAY(A2)) copy the formula down the C column, then copy the formula column and paste special values in the date column....or where ever you want it. regards FSt1 "gmboat1" wrote: I have a schedule to take meds three times a day every day every month. How can I change the name of the month by using the find and replace function or other methods...Thank YOu in advance. Greg Date Time 1-Mar 6:30 am 1-Mar 11:30 pm 1-Mar 4:30 pm 2-Mar 6:30 am 2-Mar 11:30 pm 2-Mar 4:30 pm 3-Mar 3-Mar 3-Mar 4-Mar 4-Mar 4-Mar |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with formating
hi,
if your date data in formated as text, the find and replace all will work. if your date data is fromated as date then try something like this in a blank column (in your example - column C)...... =DATE(YEAR(A2),MONTH(A)+1,DAY(A2)) copy the formula down the C column, then copy the formula column and paste special values in the date column....or where ever you want it. regards FSt1 "gmboat1" wrote: I have a schedule to take meds three times a day every day every month. How can I change the name of the month by using the find and replace function or other methods...Thank YOu in advance. Greg Date Time 1-Mar 6:30 am 1-Mar 11:30 pm 1-Mar 4:30 pm 2-Mar 6:30 am 2-Mar 11:30 pm 2-Mar 4:30 pm 3-Mar 3-Mar 3-Mar 4-Mar 4-Mar 4-Mar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formating | Excel Worksheet Functions | |||
Tab formating | Excel Discussion (Misc queries) | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Formating h:mm AM/PM | Excel Discussion (Misc queries) | |||
Formating | Excel Discussion (Misc queries) |