in reply to Re^3: excel format problem
in thread excel format problem

Actually, I think that literally putting "0x" at the beginning made it from a number to a string and now Excel leaves it alone.

Replies are listed 'Best First'.
Re^5: Excel format problem
by Athanasius (Archbishop) on Sep 04, 2014 at 03:04 UTC

    Yes, but now Excel will ignore it as a number. For example, with cell B4 containing =SUM(B1:B3):

    AB
    1 1
    2 0x2
    3 3
    4 Total: 4

    — the total is 4, not 6 as expected. As a rule, numerical data entered into an Excel spreadsheet should be available to be used as numerical data — that’s what a spreadsheet is for, after all! So, prefer choroba’s approach given above.

    Hope that helps,

    Athanasius <°(((>< contra mundum Iustus alius egestas vitae, eros Piratica,

[reply]
[d/l]

In Section Seekers of Perl Wisdom