URGENT: non-numeric values in "number" fields

[marika1981]

Hi!

I have a data table consisting of 10,000 rows with various row headers and
numerical scores, 0 through 10. All the fields containing scores are
formatted as "Number"

Problem is that I'd like, at times, to use the "NA" convention (or some
similar non-numeric convention) in instances when a score was not calculated
or isn't relevant. I'm unable, however to find a way to enter anything but
numeric values in these fields. Blanks - given their ambiguity - I very much
hope to avoid.

Any help would be TRULY APPRECIATED!!!!

Marika

 

[strive4peace]

"Problem is that I'd like, at times, to use the "NA" convention (or some
similar non-numeric convention) in instances when a score was not
calculated or isn't relevant. "

you can't have it both ways... numbers and text unless your numbers are
stored as text (okay if that is what you need and you won;t do numeric
calculations)

if stored as numbers, what you can do is format zeros to show "N/A",
but what if the value really IS zero?

nulls will show up as empty spaces (which I like because they are easier
to spot)

You have 4 choices on number format:

1. positive numbers
2. negative numbers
3. zeros
4. nulls


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*

 

[John Vinson]

Blanks - given their ambiguity - I very much
hope to avoid.

As Crystal says, you can't get away from using either NULL or numbers.
What is the sum of 3, 4, 6 and N/A?

What you *can* do is use a Format wherever the value needs to be
displayed:

#;-#;#;"N/A"

to display positive numbers as is, negative numbers preceded by a
minus sign, 0 as 0, and NULL as the text string N/A.

John W. Vinson[MVP]

 

[marika1981]

Thanks strive4peace, very helpful. . . . .

best
marika

 

[marika1981]

Oh wow - thank you!!

very helpful. . . . .

As Crystal says, you can't get away from using either NULL or numbers.
What is the sum of 3, 4, 6 and N/A?

What you *can* do is use a Format wherever the value needs to be
displayed:

#;-#;#;"N/A"

to display positive numbers as is, negative numbers preceded by a
minus sign, 0 as 0, and NULL as the text string N/A.

John W. Vinson[MVP]

 

[strive4peace]

you're welcome, Marika happy to help


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*