Ooh I am liking the ED instruction.  But I'm missing something.

My pattern is this

=XL15'20207A20207A20204B202020202020'

My data is this

=XL8'0000003082080000'

And the result I'm getting is this

'         308208'

What I want is this

'       0.308208'

What can I do to the pattern mask to force the decimal point, and at the least 
the zeros between the decimal and the first significant digit, and maybe one 
zero before the decimal point?

Janet

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Reply via email to