Lookup values won't format my numbers correctly (1 Viewer)

ncimike3

Registered User.
Local time
Today, 12:38
Joined
Jan 5, 2011
Messages
12
I have a lookup value that accesses a table. The table values are set at 3 decimals. The value that is placed into looked up and placed into the data cell is formatted to 3 decimals. In fact it even displays 3 decimals after the value is selected. The problem that is driving me nuts is wen the lookup drop down box pops up, all the values are shown to 2 decimal places. I'll attach some pics. Any help would be greatly appreciated.

Mike
 

Attachments

  • Capture1.JPG
    Capture1.JPG
    64.7 KB · Views: 92
  • Capture2.JPG
    Capture2.JPG
    40.7 KB · Views: 85

ncimike3

Registered User.
Local time
Today, 12:38
Joined
Jan 5, 2011
Messages
12
Worked like a charm. Solved. Thank you so much!
 

Users who are viewing this thread

Top Bottom