Home For accounting professionals General accounting discussion
Current updates regarding coronavirus (Covid-19) and the precautions AAT are taking will be continually updated on the below page.

Please check this link for the latest updates:
We hope you are all safe and well and if you need us we will be here. 💚


Excel - Date conversion

SueSue Well-KnownRegistered Posts: 217
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.