Look at

ToolsOptions, Edit tab, "Extend data range formats and formulas"

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"ChrisP" wrote in message
...
I have a table lookin like this

A B C
item1 7391695920135 7DTBQJP*jcabdf+
item2 7391695920128 7DTBQJP*jcabci+

The data in column C is a product of a function call.
Atm im just refering to b1 from c1 to to make use of the function.
But since this is a dokument thats going to be printed and updated several
times, Id
like to find a way to get rid of collumn B without having to type
=ean13(yadayayda) in every cell.

now to the question, Is there a cell format or something i can use so that
the function is run on all data that I type in collumn B?