Stopping large numbers being in scientific format

26 views
Skip to first unread message

Michael McGrath

unread,
Jun 24, 2013, 12:27:13 PM6/24/13
to ax...@googlegroups.com
Hello
thanks for such as useful gem -- its a real time-saver although I suspect I'm using a small fraction of its power as I only generate 'tabular' data....

My question is - I have a column than contains serial numbers which look like large numbers (e.g. 987000000100001010000) -- when the Excel doc is generated, these appear as '9.87E+20' -- how can I force a "text" format on these cells?

Thanks
Michael.
Reply all
Reply to author
Forward
0 new messages