Hi,
I initially had a problem with reading ages which had been solved but now I have another problem with the same type of issue when I save the spreadsheet as a csv file.
I have a spreadsheet showing reading ages in the format 10:05 for 10 years and 05 months which I wanted to show as 10/05 for importing into a MIS.
Either one of the following formulae, written by experts in this forum, convert the reading age and show it in the format I require (10/05). However, when I save the file as a csv and then check the data, the reading ages show as a date format.
Can anyone suggest a way around this problem?
I have attached a saved csv file showing the problem.
Thanks and regards
Bookmarks