thanks mike and gtvto6 but still stuck ;

[blabla]

--
im entering serial numbers digits leters and numbers ,but for some reason it
seems to calcualte it ,when i change the formatting after i enter on what ive
written it turns into hash marks;######### ,,alternatitively the other way
--will give something like; 4535345+E ,,,help aprreciated,

 

[Mike H]

Hi,

The best help I can offer in addition to that supplied is firstly stick to
the same thread and secondly can we see some examples of the serial numbers
you are entering.

Mike

 

[loudfish]

--
im entering serial numbers digits leters and numbers ,but for some reason it
seems to calcualte it ,when i change the formatting after i enter on what ive
written it turns into hash marks;######### ,,alternatitively the other way
--will give something like; 4535345+E ,,,help aprreciated,

Before you enter the value into the cell, format the cell as text.

Format.... Cells.... Text.

Also, its helpful, as already pointed out if you keep in the original
thread.

Cheers

Andrew