Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,452
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
DataBase worksheet function Jean-Yves[_2_] Excel Programming 0 January 31st 08 02:57 PM
Can I use a different worksheet for my database using DSUM? Sandee Excel Worksheet Functions 0 October 7th 06 06:35 PM
database over 1 worksheet kiran Excel Worksheet Functions 1 May 2nd 06 12:08 PM
Worksheet database Pepino Excel Worksheet Functions 1 March 28th 05 11:29 PM
Attaching a JET database to an Excel Worksheet OR storing large binary data in a worksheet Ant Waters Excel Programming 1 September 3rd 03 11:34 AM


All times are GMT +1. The time now is 08:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"