The cell interprets the field as a text value, so the character your left function is pulling is a text value as well.
instead of left(b2) try (left(b2)+0)
this converts the text value to a number value.
The cell interprets the field as a text value, so the character your left function is pulling is a text value as well.
instead of left(b2) try (left(b2)+0)
this converts the text value to a number value.
Please click the * icon below if I have helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks