Thank you very much for your help.
That worked great, but for some reason it didn't work on another spreadsheet I have. See attached.
When converting to text, it removed 10 dates from the axis. Not sure why! Any ideas?
Your help is greatly appreciated.
Karen