M
Mark
Having done a download to an excel spreadsheet from Sun
Accounts (using Vision)I find that the 4 chr cost codes
are formatted as general.
When I insert a new line, edit copy special all, the cost
code is the same general format definition (Note: summing
will give the value 0). BUT, if I was to type over
either of the cost codes with a new cost code this input
is treated as a value (another words the sum now equals
value of new input yet the format appears to be identical -
ie. still general.)
As I use vlookup on the cost code to reference this data
in other sheets, I could have 2 cost codes (say, 9100)
with 1 not be picked up where it has been downloaded and
the other inputted manually. (Note: Reformatting all as
value makes NO difference).
Any simple suggestions ( as I have over 1000 of these
lines to process )
thx
Mark
Accounts (using Vision)I find that the 4 chr cost codes
are formatted as general.
When I insert a new line, edit copy special all, the cost
code is the same general format definition (Note: summing
will give the value 0). BUT, if I was to type over
either of the cost codes with a new cost code this input
is treated as a value (another words the sum now equals
value of new input yet the format appears to be identical -
ie. still general.)
As I use vlookup on the cost code to reference this data
in other sheets, I could have 2 cost codes (say, 9100)
with 1 not be picked up where it has been downloaded and
the other inputted manually. (Note: Reformatting all as
value makes NO difference).
Any simple suggestions ( as I have over 1000 of these
lines to process )
thx
Mark