Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Losing all formatting in Excel 2007 files | Excel Discussion (Misc queries) | |||
macro to save current excel sheet only without losing formatting | Excel Programming | |||
Excel columns keep losing their formatting in 2007 Beta upgrade w. | Excel Discussion (Misc queries) | |||
Run An MSAccess VBA Function From Excel | Excel Programming | |||
pasting into an excel template without losing the formatting | Excel Discussion (Misc queries) |