|
| Re: QPro V8: How to combine text with number ? |
 |
Fri, 29 Feb 2008 07:18:43 -060 |
+A1&@STRING(B1,0)
|
| Post Reply
|
| QPro V8: How to combine text with number ? |
 |
Fri, 29 Feb 2008 20:39:07 +080 |
Dear Sir,
I wish to combine text in column A with numbers in column B using formula at
C1
@CONCATENATE(A10,B10).
A
B C
1
JV-PK
2008010250
JV-PK2.00801E+009
2
PAY-D-HQ
2008010251
PAY-D-HQ2.00801E+009
3
NTCINV
2008010252
NTCINV2.00801E+009
4
TCINV
2008010253
TCINV2.00801E+009
However I could not get the desired result. The number appears as
2.00081E+009 instead of 2008010250.
May I now how to overcome this problem?
Also may I know how to covert a number of 20081020125 into text
'20081020125, what formula must I use ?
Thanks
Low
|
| Post Reply
|
| Re: QPro V8: How to combine text with number ? |
 |
Fri, 29 Feb 2008 21:50:29 +080 |
Hello Kenneth,
Many thanks for your formula.
Kind Regards
Low
"Kenneth Hobson" <khobson@aaahawk.com> wrote in message
news:47c805e7_2@cnews...
>
> +A1&@STRING(B1,0)
>
|
| Post Reply
|
|
|
|
|
|
|
|
|
|