Use worksheet as database
 

Hi

I hsve a workbook that I use as database. The problem I have is then I
want to search for a date. In SQL question I need a dot (.) istead of a
(,)so I need to convert 39454,9166666667 to 39454.9166666667

Is this possible or can I solve this problem in another way?

Thanks in advace


*** Sent via Developersdex http://www.developersdex.com ***

Use worksheet as database
 

Not sure I understand the problem.
How about just do a Find/Replace in the sheet?

RBS


"Kalle" wrote in message
...


Hi

I hsve a workbook that I use as database. The problem I have is then I
want to search for a date. In SQL question I need a dot (.) istead of a
(,)so I need to convert 39454,9166666667 to 39454.9166666667

Is this possible or can I solve this problem in another way?

Thanks in advace


*** Sent via Developersdex http://www.developersdex.com ***