'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?