thanks mike and gtvto6 but still stuck ;

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

blabla - 26 May 2008 17:09 GMT

Signature

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,

Reply to this Message

Mike H - 26 May 2008 17:21 GMT

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

Reply to this Message

loudfish - 26 May 2008 20:57 GMT

> --
> 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

Reply to this Message