Date Format

[tvh]

I have the following formula in cell A9:

="NDTMTASME001Q-"&BC69&"-"&AG13

which returns: NDTMTASME001Q-40273-1626, however, the 40273 is not correct.
I would like it to be 040510.

I have a date in cell N18 formatted as mm/dd/yyyy (04/05/2010), then I have
cell BC69 set to equal N18, but in the mmddyy (040510)format.

How would I set the BC69 in the formula to read the BC69 cell exactly as it
is formatted?

Thanks...

 

[David Biddulph]

="NDTMTASME001Q-"&TEXT(BC69,"mmddyy")&"-"&AG13

 

[Paul C]

replace &BC69& with
&TEXT(BC69,"mmddyy")&

This forces the formula to use the number in the format you desire.