Share via

Maintaining a date format, when using CONCATENATE...

Anonymous
2012-06-12T13:30:02+00:00

I have a cell with "Jun-12" or a date in that format and I'm trying to pull it through to another tab...  For example: =IF('In-the-Money'!R4=TRUE,CONCATENATE('In-the-Money'!D4,'In-the-Money'!C4," ",'In-the-Money'!E4," ",'In-the-Money'!F4," ",'In-the-Money'!G4,'In-the-Money'!H4)," ").  The problem is that the date does not stay in that format.  Anyone have suggestions to maintain that date format in the string?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2012-06-12T13:48:03+00:00

That does help.  However can't get it to work perfectly.  For example:  'In-the-Money'!E2, is the date.  How does that need to be edited?  In-the-Money is the tab.  E2 is the cell.

Hi

There is no E2 in that formula so I can't alter the full formula for you but where ever it does appear then change

'In-the-Money'!E2

to

=TEXT('In-the-Money'!E2,"mmm-yy")

Was this answer helpful?

0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-06-12T13:53:57+00:00

    That does help.  However can't get it to work perfectly.  For example:  'In-the-Money'!E2, is the date.  How does that need to be edited?  In-the-Money is the tab.  E2 is the cell.

    Hi

     

    There is no E2 in that formula so I can't alter the full formula for you but where ever it does appear then change

     

    'In-the-Money'!E2

     

    to

     

    'In-the-Money'!Text(E2,"mmm-yy")

    Don't you mean this...

    Text('In-the-Money'!E2,"mmm-yy")

    Yes I do I already spotted my error and changed it, thanks

    Was this answer helpful?

    0 comments
  2. Anonymous
    2012-06-12T13:51:14+00:00

    That does help.  However can't get it to work perfectly.  For example:  'In-the-Money'!E2, is the date.  How does that need to be edited?  In-the-Money is the tab.  E2 is the cell.

    Hi

     

    There is no E2 in that formula so I can't alter the full formula for you but where ever it does appear then change

     

    'In-the-Money'!E2

     

    to

     

    'In-the-Money'!Text(E2,"mmm-yy")

    Don't you mean this...

    Text('In-the-Money'!E2,"mmm-yy")

    Was this answer helpful?

    0 comments
  3. Anonymous
    2012-06-12T13:40:52+00:00

    That does help.  However can't get it to work perfectly.  For example:  'In-the-Money'!E2, is the date.  How does that need to be edited?  In-the-Money is the tab.  E2 is the cell.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2012-06-12T13:36:14+00:00

    Hi,

    I can't see where the date is in that formula but let's assume C4 so when we concateneate it we need to format it as well like this

    TEXT(C4,"mmm-yy")

    so in the formula it becomes

    =TEXT('In-the-Money'!C4,"mmm-yy")

    Was this answer helpful?

    0 comments