Hi,

How to change numeric variables into alpha numeric ones ? I only know the

input function to do the contrary.

Thanks

Lionel

Use the PUT function.

Hi,

How to change numeric variables into alpha numeric ones ? I only know

the

input function to do the contrary.

Thanks

Lionel

Hi,

How to change numeric variables into alpha numeric ones ? I only know

the

input function to do the contrary.

Thanks

Lionel

> From: Lionel Page [mailto: XXXX@XXXXX.COM ]

keep reading until you come to the put function

CharVar = put(NumVar,NumFmt.);

examine the formats z8. which returns leading zero

and hex8. which returns hex meaning digits and A:F

Ron Fehd the macro maven CDC Atlanta GA USA XXXX@XXXXX.COM

RTFM: I'm an engineer, I don't get paid to know,

I get paid to know where to look it up.

RTFM: Read The Finite Manual.

keep reading until you come to the put function

CharVar = put(NumVar,NumFmt.);

examine the formats z8. which returns leading zero

and hex8. which returns hex meaning digits and A:F

Ron Fehd the macro maven CDC Atlanta GA USA XXXX@XXXXX.COM

RTFM: I'm an engineer, I don't get paid to know,

I get paid to know where to look it up.

RTFM: Read The Finite Manual.

Yes. Read.

Sometimes it's hard to find the right page to read. One almost has to know

the answer to find the answer. Sometimes the solution to a problem involves

synthesis of two or more features.

In this case, the INPUT function was familiar, and the documentation of the

INPUT function has a cross reference to the PUT function. Not hard at all.

On Fri, 21 May 2004 08:55:44 -0400, Fehd, Ronald J. (PHPPO) < XXXX@XXXXX.COM >

Sometimes it's hard to find the right page to read. One almost has to know

the answer to find the answer. Sometimes the solution to a problem involves

synthesis of two or more features.

In this case, the INPUT function was familiar, and the documentation of the

INPUT function has a cross reference to the PUT function. Not hard at all.

On Fri, 21 May 2004 08:55:44 -0400, Fehd, Ronald J. (PHPPO) < XXXX@XXXXX.COM >

1. putting the values of 5 different numeric variables into one numeric variable

2. Alpha with numeric and numeric only numbers in a column

3. Alphanumeric Sorting - numeric alpha numeric

4. How do I copy numeric section of cell from alpha-numeric cell

5. Extracting numeric data from an alpha numeric field

6. How to delete numeric characters in a cell with alpha numeric char

7. If statement for alpha numeric combo AND numeric only

8. only extract numeric value from alpha numeric cell

9. How do I copy numeric section of cell from alpha-numeric cell [OT]

10. Alpha Numeric tab not showing only numeric.

11. Office 2003 Excel Alpha Numeric tab not showing only numeric.

12. Stripping a String variable of any non-numeric or non-alpha characters?

13. How to sort numeric/alpha name by alpha then number in Windows Explorer

14. Display only the alpha characters in a field w/both alpha&numeric.

15. The colums changed from alpha to numeric how do you make it alpha

4 post • Page:**1** of **1**