Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
any problem here ?
on A1 i type 1/1/06 (date.Jan.1.2006)
then B1 i click fx function button click Datevalue pop-up form appear and under beside the Date_text : A1 : and from there you can see the = 38718 (my expected answer) and then hit enter. Arggghhhh. on cell B1 i see this #VALUE!. Where does this come from, since the pop-up form had already shown to me the correct result and then from nowhere somebody place in cell B1 the #VALUE!...any tricks behind this? -- "Simple things amuse simple minds" |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
any problem here ?
Formula in B1 =A1
Fomat as general "art" wrote: on A1 i type 1/1/06 (date.Jan.1.2006) then B1 i click fx function button click Datevalue pop-up form appear and under beside the Date_text : A1 : and from there you can see the = 38718 (my expected answer) and then hit enter. Arggghhhh. on cell B1 i see this #VALUE!. Where does this come from, since the pop-up form had already shown to me the correct result and then from nowhere somebody place in cell B1 the #VALUE!...any tricks behind this? -- "Simple things amuse simple minds" |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
any problem here ?
which somebody? if that fx form gave you the result-"correct one" then we may
find this function very good along with other referencing functions since we dont need to type "00/00/00" ,if the result in the form is respected by someone controlling the cell embedding result. maybe our medalist here can find acceptable solution. -- "Simple things amuse simple minds" "art" wrote: on A1 i type 1/1/06 (date.Jan.1.2006) then B1 i click fx function button click Datevalue pop-up form appear and under beside the Date_text : A1 : and from there you can see the = 38718 (my expected answer) and then hit enter. Arggghhhh. on cell B1 i see this #VALUE!. Where does this come from, since the pop-up form had already shown to me the correct result and then from nowhere somebody place in cell B1 the #VALUE!...any tricks behind this? -- "Simple things amuse simple minds" |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
any problem here ?
Teethlessmama...i know a1=b1 and formatting, what i do not know is how come
this fx form result is not the result in the cell. How to assure an incorporated or mixed functions under one formula if there is an interfacing difficulties between the form and the cell ? thanks anyway "Teethless mama" wrote: Formula in B1 =A1 Fomat as general "art" wrote: on A1 i type 1/1/06 (date.Jan.1.2006) then B1 i click fx function button click Datevalue pop-up form appear and under beside the Date_text : A1 : and from there you can see the = 38718 (my expected answer) and then hit enter. Arggghhhh. on cell B1 i see this #VALUE!. Where does this come from, since the pop-up form had already shown to me the correct result and then from nowhere somebody place in cell B1 the #VALUE!...any tricks behind this? -- "Simple things amuse simple minds" |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
any problem here ?
Don't know what you're tring to do but the DATEVALUE function argumtent MUST
be a TEXT value. For example: A1 = June (TEXT entry) =DATEVALUE(A1&" "&1) Returns the serial date for June 1 2006 = 38869 Formatted as a DATE = 6/1/2006 Biff "art" wrote in message ... on A1 i type 1/1/06 (date.Jan.1.2006) then B1 i click fx function button click Datevalue pop-up form appear and under beside the Date_text : A1 : and from there you can see the = 38718 (my expected answer) and then hit enter. Arggghhhh. on cell B1 i see this #VALUE!. Where does this come from, since the pop-up form had already shown to me the correct result and then from nowhere somebody place in cell B1 the #VALUE!...any tricks behind this? -- "Simple things amuse simple minds" |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
any problem here ?
Biff...I am not good in typing, I often use the fx Form box.....try what is
in there and see the form result then compare the cell result. A1: 1/1/06 go to cell B1, hit fx icon, then type A1 : see = very nice and simple result.... after enter u can see the difference, please try to grab the brevity. -- "Simple things amuse simple minds" "Biff" wrote: Don't know what you're tring to do but the DATEVALUE function argumtent MUST be a TEXT value. For example: A1 = June (TEXT entry) =DATEVALUE(A1&" "&1) Returns the serial date for June 1 2006 = 38869 Formatted as a DATE = 6/1/2006 Biff "art" wrote in message ... on A1 i type 1/1/06 (date.Jan.1.2006) then B1 i click fx function button click Datevalue pop-up form appear and under beside the Date_text : A1 : and from there you can see the = 38718 (my expected answer) and then hit enter. Arggghhhh. on cell B1 i see this #VALUE!. Where does this come from, since the pop-up form had already shown to me the correct result and then from nowhere somebody place in cell B1 the #VALUE!...any tricks behind this? -- "Simple things amuse simple minds" |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
any problem here ?
The Datevalue in fx fuction or in the formula. It's expect the text date.
example: in Datevalue you have to enter "1/1/2006" . It will not work when you enter A1 "art" wrote: on A1 i type 1/1/06 (date.Jan.1.2006) then B1 i click fx function button click Datevalue pop-up form appear and under beside the Date_text : A1 : and from there you can see the = 38718 (my expected answer) and then hit enter. Arggghhhh. on cell B1 i see this #VALUE!. Where does this come from, since the pop-up form had already shown to me the correct result and then from nowhere somebody place in cell B1 the #VALUE!...any tricks behind this? -- "Simple things amuse simple minds" |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
any problem here ?
Ok, I see what you're saying. To be honest, I never use the Insert function
wizzard. But, you'll notice that it says: Date_text and then down below it defines what Date_text means. It evaluates the the entry correctly but that's just an intermediate step of the WIZZARD and is not the FINAL CALCULATED RESULT. See HELP on DATEVALUE for a more detailed explanation of how it works. You'll notice that throughout the explanation is keeps mentioning that the value must be a TEXT representation of a date. Biff "art" wrote in message ... Biff...I am not good in typing, I often use the fx Form box.....try what is in there and see the form result then compare the cell result. A1: 1/1/06 go to cell B1, hit fx icon, then type A1 : see = very nice and simple result.... after enter u can see the difference, please try to grab the brevity. -- "Simple things amuse simple minds" "Biff" wrote: Don't know what you're tring to do but the DATEVALUE function argumtent MUST be a TEXT value. For example: A1 = June (TEXT entry) =DATEVALUE(A1&" "&1) Returns the serial date for June 1 2006 = 38869 Formatted as a DATE = 6/1/2006 Biff "art" wrote in message ... on A1 i type 1/1/06 (date.Jan.1.2006) then B1 i click fx function button click Datevalue pop-up form appear and under beside the Date_text : A1 : and from there you can see the = 38718 (my expected answer) and then hit enter. Arggghhhh. on cell B1 i see this #VALUE!. Where does this come from, since the pop-up form had already shown to me the correct result and then from nowhere somebody place in cell B1 the #VALUE!...any tricks behind this? -- "Simple things amuse simple minds" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
have some problem with database | Excel Discussion (Misc queries) | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
Problem With Reference Update | Excel Worksheet Functions | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) |