When exporting a saved search result, the Posting ...
# general
l
When exporting a saved search result, the Posting Period column is automatically converted to a different format. Is there a way to retain the original format after exporting?
j
@Luis This is really an Excel question, as it's Excel that's reformatting it when you open in Excel, not NetSuite's export. Select the column, right click and select Format cells. Select Custom and set to the desired format (e.g. "MMM YYYY"). If you want a different format and you're unfamiliar with custom formats in Excel, do some googling/youtubing and you'll find some good stuff.
l
Yup. But I was hoping I could create a formula in saved search to force the Period to be a String instead of Date format