Forum Discussion
Blank Values after a Left Join
Hello! I am having an issue connected with blank values. I have 2 tables that I merge using a left join. One contains data about Sales Orders and the other one contains Billing information. I m...
It is not enough to simply change the "type" of a field to "text". For example, if a number is entered and then later formated to "text", it is still a number, it just "looks" like text in that it most likely aligns to the left instead of to the right. You need to verify that values are truly numeric and/or text.
To assure a value that looks like a number is a number, I use the Excel function: =Value(
To assure a value that looks like a number is text, I use the Excel funcion: =Text(
I copy the function down the length of the data and then convert the formulas to values; i.e., I copy and paste them as values.
Good Luck ... I hope that helps.