I only wish I was in the Caribbean!

Wow, That was so easy! I had forgotten about the Format Painter! I've never really used it much, but I sure will now!

Thank you! 

---

Damien_Rosario wrote:

Hi Lisa

 

Not sure why your language is changing unless what you are copying from has a different language setting to your workbook?

 

I would suggest using Format Painter (in your Home tab), select the cell with the right format, click onto Format Painter to copy the correct cell format and click onto the desired cell to apply the correct formatting.

 

or;

 

Select the cell/s that are out of whack, right click and select Format Cells, go to Custom, enter MM-DD. 

 

It does't fix your language issue, but sometimes it's quicker to just touch up the problem than it is to try to fix it (unless someone has specifics on how to do that here?)!

 

Hope it helps.

 

Cheers

Damien

---