Forum Discussion
Search and Replace date
I have a spreadsheet showing planned expenditure per month per day in format 1-Jan I would like to be able to make multiple changes - to show "1-Jan... to 1-Feb.... to 1-Mar..." Help please MIchael...
mcadaviesuwclubnet Difficult to visualise your spreadsheet but perhaps a pivot table is what you need. If you could share a bit more about how exactly your sheet looks like that would be great. A screenshot or a share (OneDrive, for example) to an example file (without private info, of course) would be better.
- Thanks but I have just completed the long way and changed all the dates I require!
Michael Davies
