gkisystems
Board Regular
- Joined
- Apr 20, 2012
- Messages
- 76
I need to format my product item codes (SKU's) as text for my vlookup to work. Some SKU's are strictly whole numbers, some are numbers with decimal points, and some are numbers and letters.
For example, I have a list of several hundred SKU's that look like this:
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>
I tried using =TEXT(cell_number_here,"#.##") and the formula works fine except for whole number SKU's without a decimal point such as 4116325488. For that SKU, the format results in:
4116325488.
with the period at the end of the number. What formula would work so I do not get the period at the end of the whole number SKU's?
For example, I have a list of several hundred SKU's that look like this:
4116325488</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>
CL.272</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>
FV.3715LB</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>
G4611.21</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>
L37646-LBV</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>
CDA911.P134</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>
4116325488.01</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>
I tried using =TEXT(cell_number_here,"#.##") and the formula works fine except for whole number SKU's without a decimal point such as 4116325488. For that SKU, the format results in:
4116325488.
with the period at the end of the number. What formula would work so I do not get the period at the end of the whole number SKU's?