Date Format
in [Functions]
|
Prev: calculate diffence between old salary and new salary
Next: Match Account ID from combining street names and numbers
From: tvh on 5 Apr 2010 16:07 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...
From: "David Biddulph" groups [at] on 5 Apr 2010 16:21 ="NDTMTASME001Q-"&TEXT(BC69,"mmddyy")&"-"&AG13 -- David Biddulph "tvh" <tvh(a)discussions.microsoft.com> wrote in message news:B64F732B-4641-4521-8E91-7A1655158D3C(a)microsoft.com... > 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...
From: Paul C on 5 Apr 2010 16:29
replace &BC69& with &TEXT(BC69,"mmddyy")& This forces the formula to use the number in the format you desire. -- If this helps, please remember to click yes. "tvh" wrote: > 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... |