Number format - two many Decimal places????

[Guest]

Hi,

I have an excel sheet and I have that linked onto Access. I have a problem
in that my text box on my form displays a numeric field with far too many
decimal places (I only want two). The numeric field originates from a cell in
excel linked into bloomberg. This cell basically takes a real time rate off
bloomberg and I add a calculation in excel and then the result is linked into
access. Now the all the appropriate cells are formatted as numeric with 2
decimal places in excel and in Access the text box is formatted as a general
number with 2 decimal places.


Please does anyone know why all this formatting is been overridden by my
bloomberg link in which comes in with 12 odd decimal places!???

-Eamonn

 

[Dirk Goldgar]

Hi,

I have an excel sheet and I have that linked onto Access. I have a
problem in that my text box on my form displays a numeric field with
far too many decimal places (I only want two). The numeric field
originates from a cell in excel linked into bloomberg. This cell
basically takes a real time rate off bloomberg and I add a
calculation in excel and then the result is linked into access. Now
the all the appropriate cells are formatted as numeric with 2 decimal
places in excel and in Access the text box is formatted as a general
number with 2 decimal places.


Please does anyone know why all this formatting is been overridden by
my bloomberg link in which comes in with 12 odd decimal places!???

The DecimalPlaces property is ignored when you use General Number
format. Change the format to Fixed.

 

[Guest]

Nice one Dirk,
Another one bites the dust!

The DecimalPlaces property is ignored when you use General Number
format. Change the format to Fixed.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Guest]

i currently use Excel as a database with links to Bloomberg and am thinking
of using Access - how is the interface between Bloomberg/Excel/Access for
you? thx