Number format - two many Decimal places????

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Eamonn said:
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!???
Click to expand...

The DecimalPlaces property is ignored when you use General Number
format. Change the format to Fixed.
 
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
 
Back
Top