excel files extracted sage

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel files extracted from sage

Excel files extracted from sage

resolvedResolved · Low Priority · Version 2007

Neville has attended:
Excel Intermediate course
Excel Intermediate course

Excel files extracted from sage

I have tried to format the date in excel files extracted from SAGE many different ways but none work.

RE: excel files extracted from sage

Hello Neville

Thank you for your question.

This is something that will probably need to be set at the point when the data is imported, rather than trying to format the dates after they have been imported.

This is something that we could assist with, but on a consulting basis which would involve dedicated trainer time and therefore be billable.

If you would like to find out more about this option, please contact our enquiries team for a quote:
https://www.stl-training.co.uk/contact/index.php

Amanda


 

Excel tip:

Colouring cells containing formulas

Cells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells.

Follow these steps:
1. Choose Edit > Go To menu, or press either F5 or Ctrl+G. Excel displays the Go To dialog box.
2. Click Special. Excel displays the Go To Special dialog box.
3. Select the Formulas radio button option.
4. Select OK.

At this point, every formula cell in the worksheet is selected, and those cells can be coloured formatted as desired.

View all Excel hints and tips


Server loaded in 0.08 secs.