Globally define all Excel worksheets as text
Hi all,
Excel stores numbers with 16-digit precision. We work
with numbers that are larger than that, so they get
truncated. The numbers come from a CSV file created by
another application, so I can't define a column as text
and then paste in the numbers.
Is there a way to globally define Excel so as to
say "treat every workbook that you open as being all text
cells...don't convert anything into numbers."
TIA
Paul
|