View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
slickdock slickdock is offline
external usenet poster
 
Posts: 3
Default MSAccess output to Excel losing formatting of number

I have an MSAccess report whose property is =Sum([Amount]). I formatted it as
Standard with 2 decimal places and it looks perfect in msAccess. Examples:
100.00
0.00
35.42

When I use msAccess' OutputTo Excel feature, the amount column looks like
this:
100
0
35.42

What am I doing wrong? I don't want the users to have to do additional work
when it outputs to Excel. How can I make it output from msAccess properly?

Thanks in advance.