Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Custom Formatting for Dates
Is there a manner of formatting to see date as Text?, if entered in same
cell. Think that is what I need. Using custom formatting: yymmdd and making column narrow, so just see dd (with right justify). Problem is that going from text to date format, just see ## is there way to make yymmdd in custom to conform to text??? Thanks |
#2
|
|||
|
|||
Custom Formatting for Dates
a1 11/2/05
b1 =TEXT(A1,"yymmdd") you will get b1 051102 ==================== "nastech" wrote in message ... Is there a manner of formatting to see date as Text?, if entered in same cell. Think that is what I need. Using custom formatting: yymmdd and making column narrow, so just see dd (with right justify). Problem is that going from text to date format, just see ## is there way to make yymmdd in custom to conform to text??? Thanks |
#3
|
|||
|
|||
Custom Formatting for Dates
Hi, thanks for that.. don't know that much, But can I enter something like
that in custom formatting for date? (trying for all in same column, already have yymmdd in custom formatting) Thanks "R.VENKATARAMAN" wrote: a1 11/2/05 b1 =TEXT(A1,"yymmdd") you will get b1 051102 ==================== "nastech" wrote in message ... Is there a manner of formatting to see date as Text?, if entered in same cell. Think that is what I need. Using custom formatting: yymmdd and making column narrow, so just see dd (with right justify). Problem is that going from text to date format, just see ## is there way to make yymmdd in custom to conform to text??? Thanks |
#4
|
|||
|
|||
Custom Formatting for Dates
If it is a date, use just dd for the custom formatting rather than yymmdd.
"nastech" wrote: Hi, thanks for that.. don't know that much, But can I enter something like that in custom formatting for date? (trying for all in same column, already have yymmdd in custom formatting) Thanks "R.VENKATARAMAN" wrote: a1 11/2/05 b1 =TEXT(A1,"yymmdd") you will get b1 051102 ==================== "nastech" wrote in message ... Is there a manner of formatting to see date as Text?, if entered in same cell. Think that is what I need. Using custom formatting: yymmdd and making column narrow, so just see dd (with right justify). Problem is that going from text to date format, just see ## is there way to make yymmdd in custom to conform to text??? Thanks |
#5
|
|||
|
|||
Custom Formatting for Dates
oh sure, make it easy, jk.. thanks will try that
"Ralph Orth" wrote: If it is a date, use just dd for the custom formatting rather than yymmdd. "nastech" wrote: Hi, thanks for that.. don't know that much, But can I enter something like that in custom formatting for date? (trying for all in same column, already have yymmdd in custom formatting) Thanks "R.VENKATARAMAN" wrote: a1 11/2/05 b1 =TEXT(A1,"yymmdd") you will get b1 051102 ==================== "nastech" wrote in message ... Is there a manner of formatting to see date as Text?, if entered in same cell. Think that is what I need. Using custom formatting: yymmdd and making column narrow, so just see dd (with right justify). Problem is that going from text to date format, just see ## is there way to make yymmdd in custom to conform to text??? Thanks |
#6
|
|||
|
|||
Custom Formatting for Dates
I just noticed your other post, and changing the system date format in the
control panel will not affect the way Excel displays the date. I can't figure out of you are working with a date or text from what you are writing, but I think it is a date since it displays ## when you make the column narrow. In your sheet, highlight the cells you want to display as just a day, then on the menu bar on top, choose Format, then Cells, then Custom--in the Type box, type dd. Then go and change your system clock back to what you would like it to show in the lower RH corner. "nastech" wrote: Hi, thanks for that.. don't know that much, But can I enter something like that in custom formatting for date? (trying for all in same column, already have yymmdd in custom formatting) Thanks "R.VENKATARAMAN" wrote: a1 11/2/05 b1 =TEXT(A1,"yymmdd") you will get b1 051102 ==================== "nastech" wrote in message ... Is there a manner of formatting to see date as Text?, if entered in same cell. Think that is what I need. Using custom formatting: yymmdd and making column narrow, so just see dd (with right justify). Problem is that going from text to date format, just see ## is there way to make yymmdd in custom to conform to text??? Thanks |
#7
|
|||
|
|||
Custom Formatting for Dates
thanks,, system clock? don't think mentioned that, not using clock anyways,
because takes up space for task buttons, incidently/ would ask MS to put at left under start, where empty anyways.. since you're he 2nd problem was: xxxxx Trying to make a custom format for date using yymmdd Iam looking for a formula for conditional formatting, that will change color if date is older than 1 business day: (exclude saturday/sunday, legal holidays if possible) format using is: yy-mm-dd (closest could get to: yymmdd) Closest I have is: =DATEDIF(TODAY(),$A2,"M")<6 if trying to get true for < 6months, WHAT NEED: (if just dd) don't know how to modify it for if older than 1day. This is for Conditional Formatting. Thanks xxxxxxxxxx "Ralph Orth" wrote: I just noticed your other post, and changing the system date format in the control panel will not affect the way Excel displays the date. I can't figure out of you are working with a date or text from what you are writing, but I think it is a date since it displays ## when you make the column narrow. In your sheet, highlight the cells you want to display as just a day, then on the menu bar on top, choose Format, then Cells, then Custom--in the Type box, type dd. Then go and change your system clock back to what you would like it to show in the lower RH corner. "nastech" wrote: Hi, thanks for that.. don't know that much, But can I enter something like that in custom formatting for date? (trying for all in same column, already have yymmdd in custom formatting) Thanks "R.VENKATARAMAN" wrote: a1 11/2/05 b1 =TEXT(A1,"yymmdd") you will get b1 051102 ==================== "nastech" wrote in message ... Is there a manner of formatting to see date as Text?, if entered in same cell. Think that is what I need. Using custom formatting: yymmdd and making column narrow, so just see dd (with right justify). Problem is that going from text to date format, just see ## is there way to make yymmdd in custom to conform to text??? Thanks |
#8
|
|||
|
|||
Custom Formatting for Dates
Use a formula of
=workday(TODAY(),-1)<(TODAY()-1) which requires the Analysis Toolpak being installed -- HTH RP (remove nothere from the email address if mailing direct) "nastech" wrote in message ... thanks,, system clock? don't think mentioned that, not using clock anyways, because takes up space for task buttons, incidently/ would ask MS to put at left under start, where empty anyways.. since you're he 2nd problem was: xxxxx Trying to make a custom format for date using yymmdd Iam looking for a formula for conditional formatting, that will change color if date is older than 1 business day: (exclude saturday/sunday, legal holidays if possible) format using is: yy-mm-dd (closest could get to: yymmdd) Closest I have is: =DATEDIF(TODAY(),$A2,"M")<6 if trying to get true for < 6months, WHAT NEED: (if just dd) don't know how to modify it for if older than 1day. This is for Conditional Formatting. Thanks xxxxxxxxxx "Ralph Orth" wrote: I just noticed your other post, and changing the system date format in the control panel will not affect the way Excel displays the date. I can't figure out of you are working with a date or text from what you are writing, but I think it is a date since it displays ## when you make the column narrow. In your sheet, highlight the cells you want to display as just a day, then on the menu bar on top, choose Format, then Cells, then Custom--in the Type box, type dd. Then go and change your system clock back to what you would like it to show in the lower RH corner. "nastech" wrote: Hi, thanks for that.. don't know that much, But can I enter something like that in custom formatting for date? (trying for all in same column, already have yymmdd in custom formatting) Thanks "R.VENKATARAMAN" wrote: a1 11/2/05 b1 =TEXT(A1,"yymmdd") you will get b1 051102 ==================== "nastech" wrote in message ... Is there a manner of formatting to see date as Text?, if entered in same cell. Think that is what I need. Using custom formatting: yymmdd and making column narrow, so just see dd (with right justify). Problem is that going from text to date format, just see ## is there way to make yymmdd in custom to conform to text??? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom charts - default formatting | Charts and Charting in Excel | |||
Custom formatting to force a decimal place | Excel Discussion (Misc queries) | |||
custom formatting ???/???? | Excel Discussion (Misc queries) | |||
Custom formatting | Excel Discussion (Misc queries) | |||
Custom Formatting a number | Excel Discussion (Misc queries) |