Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DataBase worksheet function | Excel Programming | |||
Can I use a different worksheet for my database using DSUM? | Excel Worksheet Functions | |||
database over 1 worksheet | Excel Worksheet Functions | |||
Worksheet database | Excel Worksheet Functions | |||
Attaching a JET database to an Excel Worksheet OR storing large binary data in a worksheet | Excel Programming |