If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
custom formating a cell
Hello, I have a problem in creating a custom format and I'm running out of
time, could you please help me. I have a cell containing a series of concatenated formulas and text sections. The formula is something like this Day(A2) &" "& Month(A2)&" - "&Day(A3)&" "&month(A3). this displays correct in numbers unfortunately, I need to display the month in mmm format. so that it looks like 1 Jan - 2 Jan instead of 1 1 - 2 1 Should I use a custom number format (if so then how does it looks like) or is there a function in which I could set the format I want a section to be displayed in (something like format(month(A3, mmm) which IMO would be usefull if it isn't in excel yet) Thank you. |
#2
|
|||
|
|||
custom formating a cell
Try this:
=TEXT(A2,"d mmm")&" - "&TEXT(A3,"d mmm") "VDU" wrote: Hello, I have a problem in creating a custom format and I'm running out of time, could you please help me. I have a cell containing a series of concatenated formulas and text sections. The formula is something like this Day(A2) &" "& Month(A2)&" - "&Day(A3)&" "&month(A3). this displays correct in numbers unfortunately, I need to display the month in mmm format. so that it looks like 1 Jan - 2 Jan instead of 1 1 - 2 1 Should I use a custom number format (if so then how does it looks like) or is there a function in which I could set the format I want a section to be displayed in (something like format(month(A3, mmm) which IMO would be usefull if it isn't in excel yet) Thank you. |
#3
|
|||
|
|||
custom formating a cell
Worked perfectlly, thank you. Looks like the day and month functions are
not the best options in this case. "Teethless mama" wrote: Try this: =TEXT(A2,"d mmm")&" - "&TEXT(A3,"d mmm") "VDU" wrote: Hello, I have a problem in creating a custom format and I'm running out of time, could you please help me. I have a cell containing a series of concatenated formulas and text sections. The formula is something like this Day(A2) &" "& Month(A2)&" - "&Day(A3)&" "&month(A3). this displays correct in numbers unfortunately, I need to display the month in mmm format. so that it looks like 1 Jan - 2 Jan instead of 1 1 - 2 1 Should I use a custom number format (if so then how does it looks like) or is there a function in which I could set the format I want a section to be displayed in (something like format(month(A3, mmm) which IMO would be usefull if it isn't in excel yet) Thank you. |
Thread Tools | |
Display Modes | |
|
|