By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,891 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

Problem with decimal number smaller than 1

P: n/a
Hi everyone!

I'm accessing MS Access database trough MS Excel. I have problem with
decimal number smaller than 1.

Example: For "0.456" I retrive ".456" from database in Excel recordset. Is
there some way that ODBC driver convert ".456" value to "0.456" for
computation or I have to do it my self in program?

Thanks.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Wed, 4 Feb 2004 12:25:51 +0100, "Mlaky"
<ml*********@email.htnet.hr> wrote:

It is the same value.
If you don't like the default format, use the Format function.

-Tom.
Hi everyone!

I'm accessing MS Access database trough MS Excel. I have problem with
decimal number smaller than 1.

Example: For "0.456" I retrive ".456" from database in Excel recordset. Is
there some way that ODBC driver convert ".456" value to "0.456" for
computation or I have to do it my self in program?

Thanks.


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.