1. D

    convert ASCI date to dd/mm/yyyy

    I've a spreadsheet where the date column is 04-APR-17. By replacing the - with a / and formatting as a date I can only get it to show 4/4/2017 in the formula bar. The field however shows 42829. I need it to be 4/4/2017 (dd/mm/yyyy) All help appreciated

Some videos you may like

This Week's Hot Topics