<div>
From your example where F1 is your date &nbsp;. . . .<br />
=A1&amp;B1&amp;C1&amp;D1&amp;E1&amp;TEXT(F1,&quot;y<wbr />ymmdd&quot;)
</div>


From your example where F1 is your date  . . . .
=A1&B1&C1&D1&E1&TEXT(F1,"yymmdd")

<div>
rlistenb... thank you for chiming in. &nbsp; I'd have split points but didn't get to see your posting until question closed. &nbsp; Thank you anyways. &nbsp; ;)
</div>


rlistenb... thank you for chiming in.   I'd have split points but didn't get to see your posting until question closed.   Thank you anyways.   ;)

<div>
You can click &quot;Request Attention&quot; to have a moderator re-open the thread so that you can re-distribute the points if you like.
</div>


You can click "Request Attention" to have a moderator re-open the thread so that you can re-distribute the points if you like.

<div>
NBVC... thanks for the info. &nbsp; &nbsp;Just want to be fair here. &nbsp; You were the first person who provided a solution. &nbsp; Guess that means you deserve the points.
</div>


NBVC... thanks for the info.    Just want to be fair here.   You were the first person who provided a solution.   Guess that means you deserve the points.

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
'need some assistance with tweaking a formula/format. &nbsp; Here's what I have:<br />
<br />
Cell F1: &nbsp;=Today()<br />
Custom format: &nbsp; yymmdd<br />
Output value: 140805<br />
<br />
Now, I concatenate other fields (A1, B1, ..., ..., and F1) in cell M1. &nbsp; &nbsp;The output for the concatenated F1 value shows, however, 41856 (vs. 140805).<br />
<br />
My question: &nbsp; In the formula (M1), how can I force F1's value to show up is yymmdd?<br />
<br />
Thanks,<br />
EEH
</div>
</div>


Hello,

'need some assistance with tweaking a formula/format.   Here's what I have:

Cell F1:  =Today()
Custom format:   yymmdd
Output value: 140805

Now, I concatenate other fields (A1, B1, ..., ..., and F1) in cell M1.    The output for the concatenated F1 value shows, however, 41856 (vs. 140805).

My question:   In the formula (M1), how can I force F1's value to show up is yymmdd?

Thanks,
EEH

Custom format (value) changes in formula (format)

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.