Thread: #VALUE error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
an an is offline
external usenet poster
 
Posts: 37
Default #VALUE error

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