Home› For accounting professionals› General accounting discussion

Excel - Date conversion

SueSue Well-KnownRegistered Posts: 217
in General accounting discussion
Hi

I am trying to import my clients data from Excel into Sage. Unfortunately they have entered the date in the format of 02.05.08 whereas to import into Sage it has to be 02/05/08. Is there a quick way of changing this or is it a case of re-entering all the dates?

Sue

Comments

  • GianniGianni Feels At Home Registered Posts: 99
    Can you not just select the column you're wishing to change and use the replace option (Control + H) to replace the . to / ?
  • SueSue Well-Known Registered Posts: 217
    Hi Gianni

    Thanks for the advice, I've only just found it because for some reason my email alerts aren't working!

    I've just tried this but it didn't work, perhaps because the client initally set up the spreadsheet in Microsoft Works?

    Sue
  • GianniGianni Feels At Home Registered Posts: 99
    Hi Sue,

    I wouldn't have thought that'd make much difference. I'm guessing you've opened the works file up in Excel and then saved into Excel format afterwards? Once you've saved into excel format, it'll convert to this format from works.

    Another way perhaps is to select the column and convert the cells to date type and then try the replace function? I've tried this on Excel 2007 and it works fine.
  • SueSue Well-Known Registered Posts: 217
    Hi Gianni

    Yes, that worked!! Thanks for your help.

    Sue
Sign In or Register to comment.