Read a Number column with leading zeros

[selv...@gmail.com]

Hi all,

I am trying to open and read a xlsx file, which I have attached. The
upc column in that file, is the one I'm talking about. If I open the
file in the Open Office Spreadsheet, it is correctly displaying with
leading zeros. But if I read it with Roo gem it truncates the leading
zeros. I understand this is the expected behavior since the column
type is Number. But how is Open Office correctly displaying it? Is
there is way to achieve the same using Roo?

--
Azhagu Selvan

http://tamizhgeek.in

[SuperKevy]

You formatted the column as text.  Try inserting a single ' in front of the numbers.  Same issue as zip codes