HI,
Am in Excel, in cell A1 I have =today(), this is formatted as custom ddmmyy(which is 300902). when I reference the cell in a2 (=A1) it comes out as a1 (300902), BUT when I reference it in a3 (=d1&"/"&a1&"/"&f1) it comes out as 37502, which i guess is the unformatted date.
Can anyone help?
Am in Excel, in cell A1 I have =today(), this is formatted as custom ddmmyy(which is 300902). when I reference the cell in a2 (=A1) it comes out as a1 (300902), BUT when I reference it in a3 (=d1&"/"&a1&"/"&f1) it comes out as 37502, which i guess is the unformatted date.
Can anyone help?