Replies

John yours did the trick – ‘@’ does it. It was the formatting as you suspected.
thanks all for your help

John yours did the trick – ‘@’ does it. It was the formatting as you suspected.
thanks all for your help

I imported the numbers from Oracle and that may be the problem. When I started a new spreadsheet and just typed in numbers your method worked perfectly. I’m thinking the format or something in the date coming over from Oracle is the actual problem.
thanks for your help – it does work as you said.

I imported the numbers from Oracle and that may be the problem. When I started a new spreadsheet and just typed in numbers your method worked perfectly. I’m thinking the format or something in the date coming over from Oracle is the actual problem.
thanks for your help – it does work as you said.

I tried that but it did not work. I wonder if there is something wrong with Excel on my PC – the “sample” box does not change when I try the different formats. What do you think?
Thanks again for your reply – I think that’s the way to do it.

I tried that but it did not work. I wonder if there is something wrong with Excel on my PC – the “sample” box does not change when I try the different formats. What do you think?
Thanks again for your reply – I think that’s the way to do it.

Perfect. Thanks for your help.

Perfect. Thanks for your help.

Language: Latin based; web page font: times new roman; plain text font: courier new. On the Accessibility tab nothing is checked. Thanks

I tried it both saving the form definition and not saving the form definition. It did not make any difference. But I did find a Knowledge Base article (Q218398) that mentions putting a very small VBScript in the form and that worked! You may need it some time – I looked forever for it. Thanks for your suggestion.