seperating dates & values
 

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


--
rocket0612
------------------------------------------------------------------------
rocket0612's Profile: http://www.excelforum.com/member.php...o&userid=19492
View this thread: http://www.excelforum.com/showthread...hreadid=393789

"rocket0612" wrote:

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.

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?

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

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

many, many thanks :)


--
rocket0612
------------------------------------------------------------------------
rocket0612's Profile: http://www.excelforum.com/member.php...o&userid=19492
View this thread: http://www.excelforum.com/showthread...hreadid=393789

You're welcome !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--