what charactor to hold number space in conditional formating

  • Thread starter Thread starter Guest
  • Start date Start date
Is there a question here? Your Subject doesn't make much sense to me.

Please feel free to use the body of your posting to fully describe your
situation and question.
 
This is the area of your message where you're supposed to ask a
question, not the subject line.
Besides which, your subject line does not make much sense.
Why not try again and spend a bit of time explaining what you mean.
 
fredg said:
This is the area of your message where you're supposed to ask a
question, not the subject line.
Besides which, your subject line does not make much sense.
Why not try again and spend a bit of time explaining what you mean.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Sorry guys first time. what I am asking is when using conditional formating in a report, what charactor could I use in a 5 digit number to only use the conditons on the last 2 numbers?
Click to expand...
 
If the 5 digit number is text then
Expression Is
Right([YourFieldExpression],2) = "__"
If numeric, consider
Right(str([YourFieldExpression]),2) = "__"
 
Back
Top