Forcing a column to be formatted as text

Jan 23, 2013 at 6:42 AM

Hi,

Is there any way to force a column to be formatted as text when exported to excel? The problem is that I have ids such as '0000123123' in the column which get transformed into '123123' when exported to excel and that isn't ok.

Does anyone know how to fix this?

 

Thanks.

Jul 3, 2013 at 11:45 AM
Hi,

You can force a column to be formatted as text by prefixing the text of column with a single quote ( ' ).