Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can I get the appeared value from the cell?
let say I have a string or date variable fileDate and on "a1" I have
the date value of 2/2/2006 when I use the code filedate = formate(filedate , "YYMM") msgbox(filedate) it gives me 27/10/2064 which I have completely no clue what had happened. So I think I should try another way. using format cell I turned the appeared value of "a1" to be 0602 and I hope to get this "0602" into my variable. My problem is that when I copy the data it doesnt copy the appeared value but the genuine value 2/2/2006 which is not what i wanted |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can I get the appeared value from the cell?
FileDate = "2/2/2006"
filedate = format(cDate(filedate) , "YYMM") -- Regards, Tom Ogilvy "Raven" wrote in message oups.com... let say I have a string or date variable fileDate and on "a1" I have the date value of 2/2/2006 when I use the code filedate = formate(filedate , "YYMM") msgbox(filedate) it gives me 27/10/2064 which I have completely no clue what had happened. So I think I should try another way. using format cell I turned the appeared value of "a1" to be 0602 and I hope to get this "0602" into my variable. My problem is that when I copy the data it doesnt copy the appeared value but the genuine value 2/2/2006 which is not what i wanted |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks have appeared in all my forms, how do I remove them? | Excel Worksheet Functions | |||
a picture suddenly appeared on the worksheet | Excel Worksheet Functions | |||
Counting Cells, excluding those which have appeared before. | Excel Discussion (Misc queries) | |||
List of items appeared in range | Excel Worksheet Functions | |||
Gray box appeared around images | Excel Discussion (Misc queries) |