| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#VALUE error
Ok, GD.
Exactly. Work fine! Thank you very much. an "Gord Dibben" wrote: From where do you get the data? If imported. perhaps the space is a non-breaking space. TRIM or CLEAN functions will not remove those. Select and EditReplace What: Alt + 0160(using NumPad) With: leave blank Replace all Does that compute any better? Gord Dibben MS Excel MVP On Thu, 22 Nov 2007 12:36:01 -0800, an wrote: Thanks for reply. Don't result. The original format cell is General After change to Custom h:hh:mm AM/PM or Time format don't result too. Thanks more one time. an "Mike H" wrote: One way =TRIM(B1)-TRIM(A1) Mike "an" wrote: Hi! I have a time table with: A B 1 11:55:00 AM 2:20:00 PM If aplied the formulae =(B1-A1) return #VALUE error, because there are one space before first digit. If erased the space, work fine. With Find and Replace don't solve the problem. Is possible to solve this problem automaticly, please? Thanks in advance. an |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
| Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
| I have Error 1919 Error Configuring ODBC dataSource Database | Excel Discussion (Misc queries) | |||
| Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
Threaded Mode
