Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
"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 -- |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
You're welcome !
-- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum values between dates | Excel Worksheet Functions | |||
Using dates for x-axis values as string instead of creating a scale | Charts and Charting in Excel | |||
How to dates column with values in next column | Excel Discussion (Misc queries) | |||
FORMULA REQD FOR ADD ING DATES AND VALUES AND PART NUMBERS | Excel Discussion (Misc queries) | |||
SUM values between dates | Excel Worksheet Functions |