If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
i cant change the format of the date when referencing another cell
In cell a1 on sheet one I have a date in this format sept-28,04.
but on sheet2 in cell b1 I entered =sheet1!(A1) or however the formula goes I'm sure you know the proper formula, However it returns the same format as sheet 1 despite my request in the cell format to display a different date format. I have tried all the different formats but it stays the same as the one on sheet 1. Ultimately I would like to turn the format for sheet 2 into Tuesday, Septmeber 28, 2004. Any ideas on how to do this? Thank You Brian |
#2
|
|||
|
|||
Are you sure you have a date in Sheet1!A1? If you have a date that Excel
recognizes as a date you should be able to use a custom format like dddd, mmmm dd, yyyy sept-28,04 is text thus the result, just use 09/28/04 and format as mmm-dd,yy if you type in sept-28,04 it is seen as text -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "Brian" wrote in message ... In cell a1 on sheet one I have a date in this format sept-28,04. but on sheet2 in cell b1 I entered =sheet1!(A1) or however the formula goes I'm sure you know the proper formula, However it returns the same format as sheet 1 despite my request in the cell format to display a different date format. I have tried all the different formats but it stays the same as the one on sheet 1. Ultimately I would like to turn the format for sheet 2 into Tuesday, Septmeber 28, 2004. Any ideas on how to do this? Thank You Brian |
#3
|
|||
|
|||
Was unable to replicate your error ..
What I did .. In Sheet1 ------------- Typed a date: "28 Sep 2004" into A1 Formatted A1 as custom: mmm-dd,yy A1 displayed: Sep-28,04 In Sheet2 ------------ Put in A1: =Sheet1!A1 Formatted A1 as custom: dddd, mmmm dd, yyyy A1 displayed: Tuesday, September 28, 2004 -- Rgds Max xl 97 --- Please respond in thread xdemechanik atyahoodotcom ---- "Brian" wrote in message ... In cell a1 on sheet one I have a date in this format sept-28,04. but on sheet2 in cell b1 I entered =sheet1!(A1) or however the formula goes I'm sure you know the proper formula, However it returns the same format as sheet 1 despite my request in the cell format to display a different date format. I have tried all the different formats but it stays the same as the one on sheet 1. Ultimately I would like to turn the format for sheet 2 into Tuesday, Septmeber 28, 2004. Any ideas on how to do this? Thank You Brian |
#4
|
|||
|
|||
if you type in sept-28,04 it is seen as text
urghh, I didn't think of that, Peo g was "misled" by the OP's statement .. In cell a1 on sheet one I have a date in this format sept-28,04. -- Rgds Max xl 97 --- Please respond in thread xdemechanik atyahoodotcom ---- |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Future date in cell to change color on that date | Rich | Worksheet Functions | 3 | September 22nd, 2004 09:35 PM |
Change default date format when typing in month & day only | Ilene Reba | General Discussion | 3 | July 1st, 2004 01:41 AM |
If statement | Doug | Worksheet Functions | 9 | June 28th, 2004 06:13 AM |
Conditional format - change cell colour according to the text within it | Ian R | Worksheet Functions | 2 | June 3rd, 2004 09:59 PM |