Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Error message #VALUE!
Regarding Excel 2003.
Why does the error message #VALUE! (#VERDI! in norwegian) occur when calculating time? I'm trying to subtract one field from another containing time values (e.g. 11:30:12-11:23:34). In some fields I get the right answer and in some fields I get the error message #VERDI!, even though the format of the fileds is the same. I have used the function "copy format" to be sure they have the same format. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Error message #VALUE!
You've probably got text in some of the fields, rather than real times.
Look out for spaces, non-breaking spaces [CHAR(160)], and other non-printing characters. Changing cell format has no effect if the contents are text. -- David Biddulph "swsw" wrote in message ... Regarding Excel 2003. Why does the error message #VALUE! (#VERDI! in norwegian) occur when calculating time? I'm trying to subtract one field from another containing time values (e.g. 11:30:12-11:23:34). In some fields I get the right answer and in some fields I get the error message #VERDI!, even though the format of the fileds is the same. I have used the function "copy format" to be sure they have the same format. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Error message #VALUE!
As David mentioned, cell format has no effect. However you could format all
cells as "General" and see if any of your cells don't change. These are the ones containing text, all others should turn into numbers. "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... You've probably got text in some of the fields, rather than real times. Look out for spaces, non-breaking spaces [CHAR(160)], and other non-printing characters. Changing cell format has no effect if the contents are text. -- David Biddulph "swsw" wrote in message ... Regarding Excel 2003. Why does the error message #VALUE! (#VERDI! in norwegian) occur when calculating time? I'm trying to subtract one field from another containing time values (e.g. 11:30:12-11:23:34). In some fields I get the right answer and in some fields I get the error message #VERDI!, even though the format of the fileds is the same. I have used the function "copy format" to be sure they have the same format. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Error message #VALUE!
also for a fast check you may use the function , say =MINUTE(A1), to see if
the correct value is returned. In case of any error, the cell may need manual correction. -- Kind Regards, Satti Charvak Only an Excel Enthusiast Noida, India "Joerg Mochikun" wrote: As David mentioned, cell format has no effect. However you could format all cells as "General" and see if any of your cells don't change. These are the ones containing text, all others should turn into numbers. "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... You've probably got text in some of the fields, rather than real times. Look out for spaces, non-breaking spaces [CHAR(160)], and other non-printing characters. Changing cell format has no effect if the contents are text. -- David Biddulph "swsw" wrote in message ... Regarding Excel 2003. Why does the error message #VALUE! (#VERDI! in norwegian) occur when calculating time? I'm trying to subtract one field from another containing time values (e.g. 11:30:12-11:23:34). In some fields I get the right answer and in some fields I get the error message #VERDI!, even though the format of the fileds is the same. I have used the function "copy format" to be sure they have the same format. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Message. | Excel Discussion (Misc queries) | |||
VBA Error Message "Compile Error...." | Excel Discussion (Misc queries) | |||
VALUE error message | Excel Discussion (Misc queries) | |||
changing the message in an error message | Excel Worksheet Functions | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) |