- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
I frequently find that it takes a couple tries for Excel formatting to work. A lot of times I'll get almost all my data requests in date format for some reason. Try this:
- Format the cells the way that you want them to
- Schedule it to be sent to yourself immediately
- When the workbook arrives, open it, and you might see that the formatted cells aren't correctly formatted anymore
- Using this emailed workbook, set the formatted cells to the way you want them again
- Reschedule the emailed workbook (and not the original one) to be sent to yourself again
- If your experience is the same as mine, the cell formatting should stick now
Let me know if this works for you!
Views
Replies
0 Likes
Total Likes