seperating dates & values

R

rocket0612

2 questions,

If in Cell A1 I have a date in the formay DD/MM/YY, how do I seperate
this so in B1 it shows DD, C1 shows MM & D1 shows YY.

additioanly, I have a value £1234.56 in cell A1, how to I get the
pounds to show in B1 & the pence in C1?

many thanks
 
M

Max

rocket0612 said:
If in Cell A1 I have a date in the formay DD/MM/YY, how do I seperate
this so in B1 it shows DD, C1 shows MM & D1 shows YY.
Click to expand...

Put in:

B1: =TEXT(A1,"dd")
C1: =TEXT(A1,"mm")
D1: =TEXT(A1,"yy")
additionally, I have a value £1234.56 in cell A1, how to I get the
pounds to show in B1 & the pence in C1?
Click to expand...

Assuming the " £1234.56 " in A1 is actually a number: 1234.56
with A1 formatted to display in currency

Put in B1: =TRUNC(A1)
Format B1 as number to zero dp

Put in C1: =A1-B1
Format C1 as number to 2 dp
 
Top