T
Tim Childs
When data is imported into Excel from a separate computer
system, the amounts are held in quotes e.g.
="123.67"
When this is paste-valued, it becomes a label, NOT a value
in Excel. Pressing {F2} and return will convert it to a
label.
I have devised some code to test for data types but it
works on the table of data AFTER it has been transferred
to an array.
My question is whether the process of transferring it to
an array inevitably leads to the loss of being able to
tell whether the info is a label rather than a value.
(Disregarding explicitly storing the "type" info for each
cell).
This is long enough but maybe not very clear. Happy to
post back to clarify.
Thanks in advance
Tim
system, the amounts are held in quotes e.g.
="123.67"
When this is paste-valued, it becomes a label, NOT a value
in Excel. Pressing {F2} and return will convert it to a
label.
I have devised some code to test for data types but it
works on the table of data AFTER it has been transferred
to an array.
My question is whether the process of transferring it to
an array inevitably leads to the loss of being able to
tell whether the info is a label rather than a value.
(Disregarding explicitly storing the "type" info for each
cell).
This is long enough but maybe not very clear. Happy to
post back to clarify.
Thanks in advance
Tim