LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Losing all formatting in Excel 2007 files stumped Al Excel Discussion (Misc queries) 1 February 26th 10 04:18 AM
macro to save current excel sheet only without losing formatting Genesis Excel Programming 2 June 22nd 07 04:31 PM
Excel columns keep losing their formatting in 2007 Beta upgrade w. McNaddy Excel Discussion (Misc queries) 2 October 24th 06 01:41 PM
Run An MSAccess VBA Function From Excel Frank Excel Programming 1 April 1st 05 01:51 PM
pasting into an excel template without losing the formatting chachi Excel Discussion (Misc queries) 2 January 14th 05 04:08 AM


All times are GMT +1. The time now is 05:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"