format output

[twallstr]

I need help to format a cell in a report. The value comes from a linked excel sheet which in its turn gets its info from our business system. When exporting numbers from our business system it has the bad habit of formating numbers into a strange text like form. In excel there is a function "convert to number" that addresses this problem.
I need to format the specific cell in either in the report or query to a number. How can this be done?

Thanks in advance

/twallstr

 

[RuralGuy]

Look in VBA Help (not Access Help) under functions in the "C's" like CInt or CDbl etc. You can pretty much coerce any datatype into a different datatype.

 

[twallstr]

Will do!

Thanks!

/twallstr