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 |
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 |