I am trying to save a report in Excel & I know you can "format columns" in Reportsmith as numbers.. but when I save as Excel even if I click on "retain formatting" it formats the number columns as General. so that I have to reformat each column as a number (0.00) & hit F2 on each cell to change them into a number so that they will be recognized in formulas.
Is there any way around this? I know nothing about macros & they seem a bit complicated for such a simple problem.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.