Skip to main content

Physical Inventory – Change spreadsheet format from scientific notation to text

When creating a spreadsheet for import into POSIM, it’s recommended to format all cells as text (/knowledgebase/posim-physical-inventory/) to prevent numeric values from defaulting to scientific notation. For an already-existing spreadsheet that has not been preformatted as text, specific steps are often necessary to convert the cells back to their original format to ensure they import correctly into POSIM. This article outlines the steps to revert numeric cells that have been automatically converted to scientific notation back to text.

When making a Spreadsheet for use as an import into POSIM, it’s possible for the SKUs or UPCs to be converted to scientific notation by the spreadsheet program, which will prevent the spreadsheet from importing correctly.
physical inventory scientific notation 01

Left: SKUs incorrectly formatted to scientific notation.
Right. SKUs correctly formatted as text.

  1. Highlight the column(s) showing the numbers in scientific notation by clicking the column header. Hold down the shift key and click to select multiple columns at once.
  2. Right-click inside the column, and select the Format Cells option from the menu that appears.
  3. In the Format Cells menu under the Number tab, set the format as Number with Decimal places set to 0. This should cause the incorrectly formatted numbers to display in their entirety.
    physical inventory scientific notation 02
    Select Number, and set decimal places to zero to undo the scientific format.
  4. Next, pick the Save As option under File, name the document, and save the file type as Text (Tab delimited).
    physical inventory scientific notation 03
    Save the corrected spreadsheet as Text (tab delimited).
  5. Now create a brand new spreadsheet, select all cells, formatting them as text. See /knowledgebase/posim-physical-inventory/ for detailed instructions on formatting a spreadsheet as text.
  6. In a text editor like Notepad, open the text (tab delimited) document from Step 4, highlight all information, right-click, and select Copy.
    physical inventory scientific notation 04
    Highlight and copy all information from the text (tab delimited) file in Notepad.
  7. Select all cells and paste the copied text document into the newly formatted spreadsheet from Step 5 and save that spreadsheet as a .xlsx document.
    physical inventory scientific notation 05
    The correctly formatted spreadsheet is now ready to import into POSIM.

 

[gravityform id="16" title="false" description="false" ajax="true" tabindex="88" field_values="guide=liquor-retail-toolkit"]
<div class='gf_browser_unknown gform_wrapper' id='gform_wrapper_16' ><div id='gf_16' class='gform_anchor' tabindex='-1'></div><form method='post' enctype='multipart/form-data' target='gform_ajax_frame_16' id='gform_16' action='/knowledgebase/physical-inventory-change-spreadsheet-format-scientific-notation-text/#gf_16'> <div class='gform_body'><ul id='gform_fields_16' class='gform_fields top_label form_sublabel_below description_below'><li id='field_16_6' class='gfield gform_hidden field_sublabel_below field_description_below gfield_visibility_visible' ><input name='input_6' id='input_16_6' type='hidden' class='gform_hidden' aria-invalid="false" value='https://app-3QNL6WU154.marketingautomation.services/webforms/receivePostback/MzawMDG3NDO0AAA/' /></li><li id='field_16_7' class='gfield gform_hidden field_sublabel_below field_description_below gfield_visibility_visible' ><input name='input_7' id='input_16_7' type='hidden' class='gform_hidden' aria-invalid="false" value='dd23239b-5ce4-47fc-98d6-c39e068f4990' /></li><li id='field_16_10' class='gfield gform_hidden field_sublabel_below field_description_below gfield_visibility_visible' ><input name='input_10' id='input_16_10' type='hidden' class='gform_hidden' aria-invalid="false" value='liquor-retail-toolkit' /></li><li id='field_16_8' class='gfield gform_hidden field_sublabel_below field_description_below gfield_visibility_visible' ><input name='input_8' id='input_16_8' type='hidden' class='gform_hidden' aria-invalid="false" value='POSIM' /></li><li id='field_16_13' class='gfield gfield_contains_required field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_16_13' >First<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_text'><input name='input_13' id='input_16_13' type='text' value='' class='large' tabindex='88' placeholder='First Name' aria-required="true" aria-invalid="false" /></div></li><li id='field_16_14' class='gfield gfield_contains_required field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_16_14' >Last<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_text'><input name='input_14' id='input_16_14' type='text' value='' class='large' tabindex='89' placeholder='Last Name' aria-required="true" aria-invalid="false" /></div></li><li id='field_16_2' class='gfield posim-email gfield_contains_required field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_16_2' >Email<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_email'> <input name='input_2' id='input_16_2' type='text' value='' class='large' tabindex='90' placeholder='Email' aria-required="true" aria-invalid="false" /> </div></li><li id='field_16_3' class='gfield posim-phone field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_16_3' >Phone</label><div class='ginput_container ginput_container_phone'><input name='input_3' id='input_16_3' type='text' value='' class='large' tabindex='91' placeholder='Phone' aria-invalid="false" /></div></li><li id='field_16_5' class='gfield posim-industry gfield_contains_required field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_16_5' >Your Industry<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_select'><select name='input_5' id='input_16_5' class='large gfield_select' tabindex='92' aria-required="true" aria-invalid="false"><option value='' selected='selected' class='gf_placeholder'>Your Industry</option><option value='Apparel' >Apparel</option><option value='Hobby' >Hobby</option><option value='Household' >Household</option><option value='Liquor, Wine &amp; Beer' >Liquor, Wine &amp; Beer</option><option value='Needlearts' >Needlearts</option><option value='Quilt, Fabric &amp; Sewing' >Quilt, Fabric &amp; Sewing</option><option value='Outdoor' >Outdoor</option><option value='Other' >Other</option></select></div></li><li id='field_16_11' class='gfield field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_16_11' >CAPTCHA</label><div id='input_16_11' class='ginput_container ginput_recaptcha' data-sitekey='6LcWicwZAAAAAF6_JZFIf_bEpNSyHe5AsCdrkgmD' data-theme='light' data-tabindex='-1' data-size='invisible' data-badge='bottomright'></div></li><li id='field_16_15' class='gfield gform_validation_container field_sublabel_below field_description_below gfield_visibility_visible' ><label class='gfield_label' for='input_16_15' >Phone</label><div class='ginput_container'><input name='input_15' id='input_16_15' type='text' value='' /></div><div class='gfield_description' id='gfield_description_16_15'>This field is for validation purposes and should be left unchanged.</div></li> </ul></div> <div class='gform_footer top_label'> <input type="submit" id="gform_submit_button_16" class="gform_button button om-trigger-conversion" value="Send My Resource" tabindex="93" onclick='if(window["gf_submitting_16"]){return false;} window["gf_submitting_16"]=true; ' onkeypress='if( event.keyCode == 13 ){ if(window["gf_submitting_16"]){return false;} window["gf_submitting_16"]=true; jQuery("#gform_16").trigger("submit",[true]); }'> <input type='hidden' name='gform_ajax' value='form_id=16&amp;title=&amp;description=&amp;tabindex=88' /> <input type='hidden' class='gform_hidden' name='is_submit_16' value='1' /> <input type='hidden' class='gform_hidden' name='gform_submit' value='16' /> <input type='hidden' class='gform_hidden' name='gform_unique_id' value='' /> <input type='hidden' class='gform_hidden' name='state_16' value='WyJbXSIsIjFmYmJkMmM5NDAyMGYzNTJmZGM3MmU0ODNlNDM2YjBmIl0=' /> <input type='hidden' class='gform_hidden' name='gform_target_page_number_16' id='gform_target_page_number_16' value='0' /> <input type='hidden' class='gform_hidden' name='gform_source_page_number_16' id='gform_source_page_number_16' value='1' /> <input type='hidden' name='gform_field_values' value='guide=liquor-retail-toolkit' /> </div> </form> </div> <iframe style='display:none;width:0px;height:0px;' src='about:blank' name='gform_ajax_frame_16' id='gform_ajax_frame_16' title='This iframe contains the logic required to handle Ajax powered Gravity Forms.'></iframe> <script type='text/javascript'>jQuery(document).ready(function($){gformInitSpinner( 16, 'https://posim.com/wp-content/plugins/gravityforms/images/spinner.gif' );jQuery('#gform_ajax_frame_16').on('load',function(){var contents = jQuery(this).contents().find('*').html();var is_postback = contents.indexOf('GF_AJAX_POSTBACK') >= 0;if(!is_postback){return;}var form_content = jQuery(this).contents().find('#gform_wrapper_16');var is_confirmation = jQuery(this).contents().find('#gform_confirmation_wrapper_16').length > 0;var is_redirect = contents.indexOf('gformRedirect(){') >= 0;var is_form = form_content.length > 0 && ! is_redirect && ! is_confirmation;var mt = parseInt(jQuery('html').css('margin-top'), 10) + parseInt(jQuery('body').css('margin-top'), 10) + 100;if(is_form){jQuery('#gform_wrapper_16').html(form_content.html());if(form_content.hasClass('gform_validation_error')){jQuery('#gform_wrapper_16').addClass('gform_validation_error');} else {jQuery('#gform_wrapper_16').removeClass('gform_validation_error');}setTimeout( function() { /* delay the scroll by 50 milliseconds to fix a bug in chrome */ jQuery(document).scrollTop(jQuery('#gform_wrapper_16').offset().top - mt); }, 50 );if(window['gformInitDatepicker']) {gformInitDatepicker();}if(window['gformInitPriceFields']) {gformInitPriceFields();}var current_page = jQuery('#gform_source_page_number_16').val();gformInitSpinner( 16, 'https://posim.com/wp-content/plugins/gravityforms/images/spinner.gif' );jQuery(document).trigger('gform_page_loaded', [16, current_page]);window['gf_submitting_16'] = false;}else if(!is_redirect){var confirmation_content = jQuery(this).contents().find('.GF_AJAX_POSTBACK').html();if(!confirmation_content){confirmation_content = contents;}setTimeout(function(){jQuery('#gform_wrapper_16').replaceWith(confirmation_content);jQuery(document).scrollTop(jQuery('#gf_16').offset().top - mt);jQuery(document).trigger('gform_confirmation_loaded', [16]);window['gf_submitting_16'] = false;}, 50);}else{jQuery('#gform_16').append(contents);if(window['gformRedirect']) {gformRedirect();}}jQuery(document).trigger('gform_post_render', [16, current_page]);} );} );</script><script type='text/javascript'> jQuery(document).bind('gform_post_render', function(event, formId, currentPage){if(formId == 16) {if(typeof Placeholders != 'undefined'){ Placeholders.enable(); }} } );jQuery(document).bind('gform_post_conditional_logic', function(event, formId, fields, isInit){} );</script><script type='text/javascript'> jQuery(document).ready(function(){jQuery(document).trigger('gform_post_render', [16, 1]) } ); </script>
[gravityform id="16" title="false" description="false" ajax="true" tabindex="88" field_values="guide=how-well-does-your-pos-measure-up"]
<div class='gf_browser_unknown gform_wrapper' id='gform_wrapper_16' ><div id='gf_16' class='gform_anchor' tabindex='-1'></div><form method='post' enctype='multipart/form-data' target='gform_ajax_frame_16' id='gform_16' action='/knowledgebase/physical-inventory-change-spreadsheet-format-scientific-notation-text/#gf_16'> <div class='gform_body'><ul id='gform_fields_16' class='gform_fields top_label form_sublabel_below description_below'><li id='field_16_6' class='gfield gform_hidden field_sublabel_below field_description_below gfield_visibility_visible' ><input name='input_6' id='input_16_6' type='hidden' class='gform_hidden' aria-invalid="false" value='https://app-3QNL6WU154.marketingautomation.services/webforms/receivePostback/MzawMDG3NDO0AAA/' /></li><li id='field_16_7' class='gfield gform_hidden field_sublabel_below field_description_below gfield_visibility_visible' ><input name='input_7' id='input_16_7' type='hidden' class='gform_hidden' aria-invalid="false" value='dd23239b-5ce4-47fc-98d6-c39e068f4990' /></li><li id='field_16_10' class='gfield gform_hidden field_sublabel_below field_description_below gfield_visibility_visible' ><input name='input_10' id='input_16_10' type='hidden' class='gform_hidden' aria-invalid="false" value='how-well-does-your-pos-measure-up' /></li><li id='field_16_8' class='gfield gform_hidden field_sublabel_below field_description_below gfield_visibility_visible' ><input name='input_8' id='input_16_8' type='hidden' class='gform_hidden' aria-invalid="false" value='POSIM' /></li><li id='field_16_13' class='gfield gfield_contains_required field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_16_13' >First<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_text'><input name='input_13' id='input_16_13' type='text' value='' class='large' tabindex='88' placeholder='First Name' aria-required="true" aria-invalid="false" /></div></li><li id='field_16_14' class='gfield gfield_contains_required field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_16_14' >Last<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_text'><input name='input_14' id='input_16_14' type='text' value='' class='large' tabindex='89' placeholder='Last Name' aria-required="true" aria-invalid="false" /></div></li><li id='field_16_2' class='gfield posim-email gfield_contains_required field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_16_2' >Email<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_email'> <input name='input_2' id='input_16_2' type='text' value='' class='large' tabindex='90' placeholder='Email' aria-required="true" aria-invalid="false" /> </div></li><li id='field_16_3' class='gfield posim-phone field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_16_3' >Phone</label><div class='ginput_container ginput_container_phone'><input name='input_3' id='input_16_3' type='text' value='' class='large' tabindex='91' placeholder='Phone' aria-invalid="false" /></div></li><li id='field_16_5' class='gfield posim-industry gfield_contains_required field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_16_5' >Your Industry<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_select'><select name='input_5' id='input_16_5' class='large gfield_select' tabindex='92' aria-required="true" aria-invalid="false"><option value='' selected='selected' class='gf_placeholder'>Your Industry</option><option value='Apparel' >Apparel</option><option value='Hobby' >Hobby</option><option value='Household' >Household</option><option value='Liquor, Wine &amp; Beer' >Liquor, Wine &amp; Beer</option><option value='Needlearts' >Needlearts</option><option value='Quilt, Fabric &amp; Sewing' >Quilt, Fabric &amp; Sewing</option><option value='Outdoor' >Outdoor</option><option value='Other' >Other</option></select></div></li><li id='field_16_11' class='gfield field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_16_11' >CAPTCHA</label><div id='input_16_11' class='ginput_container ginput_recaptcha' data-sitekey='6LcWicwZAAAAAF6_JZFIf_bEpNSyHe5AsCdrkgmD' data-theme='light' data-tabindex='-1' data-size='invisible' data-badge='bottomright'></div></li><li id='field_16_15' class='gfield gform_validation_container field_sublabel_below field_description_below gfield_visibility_visible' ><label class='gfield_label' for='input_16_15' >Email</label><div class='ginput_container'><input name='input_15' id='input_16_15' type='text' value='' /></div><div class='gfield_description' id='gfield_description_16_15'>This field is for validation purposes and should be left unchanged.</div></li> </ul></div> <div class='gform_footer top_label'> <input type="submit" id="gform_submit_button_16" class="gform_button button om-trigger-conversion" value="Send My Resource" tabindex="93" onclick='if(window["gf_submitting_16"]){return false;} window["gf_submitting_16"]=true; ' onkeypress='if( event.keyCode == 13 ){ if(window["gf_submitting_16"]){return false;} window["gf_submitting_16"]=true; jQuery("#gform_16").trigger("submit",[true]); }'> <input type='hidden' name='gform_ajax' value='form_id=16&amp;title=&amp;description=&amp;tabindex=88' /> <input type='hidden' class='gform_hidden' name='is_submit_16' value='1' /> <input type='hidden' class='gform_hidden' name='gform_submit' value='16' /> <input type='hidden' class='gform_hidden' name='gform_unique_id' value='' /> <input type='hidden' class='gform_hidden' name='state_16' value='WyJbXSIsIjFmYmJkMmM5NDAyMGYzNTJmZGM3MmU0ODNlNDM2YjBmIl0=' /> <input type='hidden' class='gform_hidden' name='gform_target_page_number_16' id='gform_target_page_number_16' value='0' /> <input type='hidden' class='gform_hidden' name='gform_source_page_number_16' id='gform_source_page_number_16' value='1' /> <input type='hidden' name='gform_field_values' value='guide=how-well-does-your-pos-measure-up' /> </div> </form> </div> <iframe style='display:none;width:0px;height:0px;' src='about:blank' name='gform_ajax_frame_16' id='gform_ajax_frame_16' title='This iframe contains the logic required to handle Ajax powered Gravity Forms.'></iframe> <script type='text/javascript'>jQuery(document).ready(function($){gformInitSpinner( 16, 'https://posim.com/wp-content/plugins/gravityforms/images/spinner.gif' );jQuery('#gform_ajax_frame_16').on('load',function(){var contents = jQuery(this).contents().find('*').html();var is_postback = contents.indexOf('GF_AJAX_POSTBACK') >= 0;if(!is_postback){return;}var form_content = jQuery(this).contents().find('#gform_wrapper_16');var is_confirmation = jQuery(this).contents().find('#gform_confirmation_wrapper_16').length > 0;var is_redirect = contents.indexOf('gformRedirect(){') >= 0;var is_form = form_content.length > 0 && ! is_redirect && ! is_confirmation;var mt = parseInt(jQuery('html').css('margin-top'), 10) + parseInt(jQuery('body').css('margin-top'), 10) + 100;if(is_form){jQuery('#gform_wrapper_16').html(form_content.html());if(form_content.hasClass('gform_validation_error')){jQuery('#gform_wrapper_16').addClass('gform_validation_error');} else {jQuery('#gform_wrapper_16').removeClass('gform_validation_error');}setTimeout( function() { /* delay the scroll by 50 milliseconds to fix a bug in chrome */ jQuery(document).scrollTop(jQuery('#gform_wrapper_16').offset().top - mt); }, 50 );if(window['gformInitDatepicker']) {gformInitDatepicker();}if(window['gformInitPriceFields']) {gformInitPriceFields();}var current_page = jQuery('#gform_source_page_number_16').val();gformInitSpinner( 16, 'https://posim.com/wp-content/plugins/gravityforms/images/spinner.gif' );jQuery(document).trigger('gform_page_loaded', [16, current_page]);window['gf_submitting_16'] = false;}else if(!is_redirect){var confirmation_content = jQuery(this).contents().find('.GF_AJAX_POSTBACK').html();if(!confirmation_content){confirmation_content = contents;}setTimeout(function(){jQuery('#gform_wrapper_16').replaceWith(confirmation_content);jQuery(document).scrollTop(jQuery('#gf_16').offset().top - mt);jQuery(document).trigger('gform_confirmation_loaded', [16]);window['gf_submitting_16'] = false;}, 50);}else{jQuery('#gform_16').append(contents);if(window['gformRedirect']) {gformRedirect();}}jQuery(document).trigger('gform_post_render', [16, current_page]);} );} );</script><script type='text/javascript'> jQuery(document).bind('gform_post_render', function(event, formId, currentPage){if(formId == 16) {if(typeof Placeholders != 'undefined'){ Placeholders.enable(); }} } );jQuery(document).bind('gform_post_conditional_logic', function(event, formId, fields, isInit){} );</script><script type='text/javascript'> jQuery(document).ready(function(){jQuery(document).trigger('gform_post_render', [16, 1]) } ); </script>
[gravityform id="16" title="false" description="false" ajax="true" tabindex="88" field_values="guide=countdown-to-the-holidays"]
<div class='gf_browser_unknown gform_wrapper' id='gform_wrapper_16' ><div id='gf_16' class='gform_anchor' tabindex='-1'></div><form method='post' enctype='multipart/form-data' target='gform_ajax_frame_16' id='gform_16' action='/knowledgebase/physical-inventory-change-spreadsheet-format-scientific-notation-text/#gf_16'> <div class='gform_body'><ul id='gform_fields_16' class='gform_fields top_label form_sublabel_below description_below'><li id='field_16_6' class='gfield gform_hidden field_sublabel_below field_description_below gfield_visibility_visible' ><input name='input_6' id='input_16_6' type='hidden' class='gform_hidden' aria-invalid="false" value='https://app-3QNL6WU154.marketingautomation.services/webforms/receivePostback/MzawMDG3NDO0AAA/' /></li><li id='field_16_7' class='gfield gform_hidden field_sublabel_below field_description_below gfield_visibility_visible' ><input name='input_7' id='input_16_7' type='hidden' class='gform_hidden' aria-invalid="false" value='dd23239b-5ce4-47fc-98d6-c39e068f4990' /></li><li id='field_16_10' class='gfield gform_hidden field_sublabel_below field_description_below gfield_visibility_visible' ><input name='input_10' id='input_16_10' type='hidden' class='gform_hidden' aria-invalid="false" value='countdown-to-the-holidays' /></li><li id='field_16_8' class='gfield gform_hidden field_sublabel_below field_description_below gfield_visibility_visible' ><input name='input_8' id='input_16_8' type='hidden' class='gform_hidden' aria-invalid="false" value='POSIM' /></li><li id='field_16_13' class='gfield gfield_contains_required field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_16_13' >First<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_text'><input name='input_13' id='input_16_13' type='text' value='' class='large' tabindex='88' placeholder='First Name' aria-required="true" aria-invalid="false" /></div></li><li id='field_16_14' class='gfield gfield_contains_required field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_16_14' >Last<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_text'><input name='input_14' id='input_16_14' type='text' value='' class='large' tabindex='89' placeholder='Last Name' aria-required="true" aria-invalid="false" /></div></li><li id='field_16_2' class='gfield posim-email gfield_contains_required field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_16_2' >Email<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_email'> <input name='input_2' id='input_16_2' type='text' value='' class='large' tabindex='90' placeholder='Email' aria-required="true" aria-invalid="false" /> </div></li><li id='field_16_3' class='gfield posim-phone field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_16_3' >Phone</label><div class='ginput_container ginput_container_phone'><input name='input_3' id='input_16_3' type='text' value='' class='large' tabindex='91' placeholder='Phone' aria-invalid="false" /></div></li><li id='field_16_5' class='gfield posim-industry gfield_contains_required field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_16_5' >Your Industry<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_select'><select name='input_5' id='input_16_5' class='large gfield_select' tabindex='92' aria-required="true" aria-invalid="false"><option value='' selected='selected' class='gf_placeholder'>Your Industry</option><option value='Apparel' >Apparel</option><option value='Hobby' >Hobby</option><option value='Household' >Household</option><option value='Liquor, Wine &amp; Beer' >Liquor, Wine &amp; Beer</option><option value='Needlearts' >Needlearts</option><option value='Quilt, Fabric &amp; Sewing' >Quilt, Fabric &amp; Sewing</option><option value='Outdoor' >Outdoor</option><option value='Other' >Other</option></select></div></li><li id='field_16_11' class='gfield field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_16_11' >CAPTCHA</label><div id='input_16_11' class='ginput_container ginput_recaptcha' data-sitekey='6LcWicwZAAAAAF6_JZFIf_bEpNSyHe5AsCdrkgmD' data-theme='light' data-tabindex='-1' data-size='invisible' data-badge='bottomright'></div></li><li id='field_16_15' class='gfield gform_validation_container field_sublabel_below field_description_below gfield_visibility_visible' ><label class='gfield_label' for='input_16_15' >Email</label><div class='ginput_container'><input name='input_15' id='input_16_15' type='text' value='' /></div><div class='gfield_description' id='gfield_description_16_15'>This field is for validation purposes and should be left unchanged.</div></li> </ul></div> <div class='gform_footer top_label'> <input type="submit" id="gform_submit_button_16" class="gform_button button om-trigger-conversion" value="Send My Resource" tabindex="93" onclick='if(window["gf_submitting_16"]){return false;} window["gf_submitting_16"]=true; ' onkeypress='if( event.keyCode == 13 ){ if(window["gf_submitting_16"]){return false;} window["gf_submitting_16"]=true; jQuery("#gform_16").trigger("submit",[true]); }'> <input type='hidden' name='gform_ajax' value='form_id=16&amp;title=&amp;description=&amp;tabindex=88' /> <input type='hidden' class='gform_hidden' name='is_submit_16' value='1' /> <input type='hidden' class='gform_hidden' name='gform_submit' value='16' /> <input type='hidden' class='gform_hidden' name='gform_unique_id' value='' /> <input type='hidden' class='gform_hidden' name='state_16' value='WyJbXSIsIjFmYmJkMmM5NDAyMGYzNTJmZGM3MmU0ODNlNDM2YjBmIl0=' /> <input type='hidden' class='gform_hidden' name='gform_target_page_number_16' id='gform_target_page_number_16' value='0' /> <input type='hidden' class='gform_hidden' name='gform_source_page_number_16' id='gform_source_page_number_16' value='1' /> <input type='hidden' name='gform_field_values' value='guide=countdown-to-the-holidays' /> </div> </form> </div> <iframe style='display:none;width:0px;height:0px;' src='about:blank' name='gform_ajax_frame_16' id='gform_ajax_frame_16' title='This iframe contains the logic required to handle Ajax powered Gravity Forms.'></iframe> <script type='text/javascript'>jQuery(document).ready(function($){gformInitSpinner( 16, 'https://posim.com/wp-content/plugins/gravityforms/images/spinner.gif' );jQuery('#gform_ajax_frame_16').on('load',function(){var contents = jQuery(this).contents().find('*').html();var is_postback = contents.indexOf('GF_AJAX_POSTBACK') >= 0;if(!is_postback){return;}var form_content = jQuery(this).contents().find('#gform_wrapper_16');var is_confirmation = jQuery(this).contents().find('#gform_confirmation_wrapper_16').length > 0;var is_redirect = contents.indexOf('gformRedirect(){') >= 0;var is_form = form_content.length > 0 && ! is_redirect && ! is_confirmation;var mt = parseInt(jQuery('html').css('margin-top'), 10) + parseInt(jQuery('body').css('margin-top'), 10) + 100;if(is_form){jQuery('#gform_wrapper_16').html(form_content.html());if(form_content.hasClass('gform_validation_error')){jQuery('#gform_wrapper_16').addClass('gform_validation_error');} else {jQuery('#gform_wrapper_16').removeClass('gform_validation_error');}setTimeout( function() { /* delay the scroll by 50 milliseconds to fix a bug in chrome */ jQuery(document).scrollTop(jQuery('#gform_wrapper_16').offset().top - mt); }, 50 );if(window['gformInitDatepicker']) {gformInitDatepicker();}if(window['gformInitPriceFields']) {gformInitPriceFields();}var current_page = jQuery('#gform_source_page_number_16').val();gformInitSpinner( 16, 'https://posim.com/wp-content/plugins/gravityforms/images/spinner.gif' );jQuery(document).trigger('gform_page_loaded', [16, current_page]);window['gf_submitting_16'] = false;}else if(!is_redirect){var confirmation_content = jQuery(this).contents().find('.GF_AJAX_POSTBACK').html();if(!confirmation_content){confirmation_content = contents;}setTimeout(function(){jQuery('#gform_wrapper_16').replaceWith(confirmation_content);jQuery(document).scrollTop(jQuery('#gf_16').offset().top - mt);jQuery(document).trigger('gform_confirmation_loaded', [16]);window['gf_submitting_16'] = false;}, 50);}else{jQuery('#gform_16').append(contents);if(window['gformRedirect']) {gformRedirect();}}jQuery(document).trigger('gform_post_render', [16, current_page]);} );} );</script><script type='text/javascript'> jQuery(document).bind('gform_post_render', function(event, formId, currentPage){if(formId == 16) {if(typeof Placeholders != 'undefined'){ Placeholders.enable(); }} } );jQuery(document).bind('gform_post_conditional_logic', function(event, formId, fields, isInit){} );</script><script type='text/javascript'> jQuery(document).ready(function(){jQuery(document).trigger('gform_post_render', [16, 1]) } ); </script>
[gravityform id="17" title="false" description="false" ajax="true" tabindex="88"]
<div class='gf_browser_unknown gform_wrapper' id='gform_wrapper_17' ><div id='gf_17' class='gform_anchor' tabindex='-1'></div><form method='post' enctype='multipart/form-data' target='gform_ajax_frame_17' id='gform_17' action='/knowledgebase/physical-inventory-change-spreadsheet-format-scientific-notation-text/#gf_17'> <div class='gform_body'><ul id='gform_fields_17' class='gform_fields top_label form_sublabel_below description_below'><li id='field_17_6' class='gfield gform_hidden field_sublabel_below field_description_below gfield_visibility_visible' ><input name='input_6' id='input_17_6' type='hidden' class='gform_hidden' aria-invalid="false" value='https://app-3QNL6WU154.marketingautomation.services/webforms/receivePostback/MzawMDG3NDO0AAA/' /></li><li id='field_17_7' class='gfield gform_hidden field_sublabel_below field_description_below gfield_visibility_visible' ><input name='input_7' id='input_17_7' type='hidden' class='gform_hidden' aria-invalid="false" value='0994ba05-06b3-460d-b11c-4f3b11093ec9' /></li><li id='field_17_8' class='gfield gform_hidden field_sublabel_below field_description_below gfield_visibility_visible' ><input name='input_8' id='input_17_8' type='hidden' class='gform_hidden' aria-invalid="false" value='POSIM' /></li><li id='field_17_11' class='gfield gfield_contains_required field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_17_11' >First<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_text'><input name='input_11' id='input_17_11' type='text' value='' class='large' tabindex='88' placeholder='First Name' aria-required="true" aria-invalid="false" /></div></li><li id='field_17_10' class='gfield gfield_contains_required field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_17_10' >Last<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_text'><input name='input_10' id='input_17_10' type='text' value='' class='large' tabindex='89' placeholder='Last Name' aria-required="true" aria-invalid="false" /></div></li><li id='field_17_2' class='gfield posim-email gfield_contains_required field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_17_2' >Email<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_email'> <input name='input_2' id='input_17_2' type='text' value='' class='large' tabindex='90' placeholder='Email' aria-required="true" aria-invalid="false" /> </div></li><li id='field_17_3' class='gfield posim-phone gfield_contains_required field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_17_3' >Phone<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_phone'><input name='input_3' id='input_17_3' type='text' value='' class='large' tabindex='91' placeholder='Phone' aria-required="true" aria-invalid="false" /></div></li><li id='field_17_5' class='gfield posim-industry gfield_contains_required field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_17_5' >Your Industry<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_select'><select name='input_5' id='input_17_5' class='large gfield_select' tabindex='92' aria-required="true" aria-invalid="false"><option value='' selected='selected' class='gf_placeholder'>Your Industry</option><option value='Apparel' >Apparel</option><option value='Hobby' >Hobby</option><option value='Household' >Household</option><option value='Liquor_Wine_Beer' >Liquor, Wine &amp; Beer</option><option value='Needlearts' >Needlearts</option><option value='Quilt_Fabric_Sewing' >Quilt, Fabric &amp; Sewing</option><option value='Outdoor' >Outdoor</option><option value='Other' >Other</option></select></div></li><li id='field_17_12' class='gfield field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_17_12' >CAPTCHA</label><div id='input_17_12' class='ginput_container ginput_recaptcha' data-sitekey='6LcWicwZAAAAAF6_JZFIf_bEpNSyHe5AsCdrkgmD' data-theme='light' data-tabindex='-1' data-size='invisible' data-badge='bottomright'></div></li><li id='field_17_13' class='gfield gform_validation_container field_sublabel_below field_description_below gfield_visibility_visible' ><label class='gfield_label' for='input_17_13' >Phone</label><div class='ginput_container'><input name='input_13' id='input_17_13' type='text' value='' /></div><div class='gfield_description' id='gfield_description_17_13'>This field is for validation purposes and should be left unchanged.</div></li> </ul></div> <div class='gform_footer top_label'> <input type="submit" id="gform_submit_button_17" class="gform_button button om-trigger-conversion" value="Request My Demo" tabindex="93" onclick='if(window["gf_submitting_17"]){return false;} window["gf_submitting_17"]=true; ' onkeypress='if( event.keyCode == 13 ){ if(window["gf_submitting_17"]){return false;} window["gf_submitting_17"]=true; jQuery("#gform_17").trigger("submit",[true]); }'> <input type='hidden' name='gform_ajax' value='form_id=17&amp;title=&amp;description=&amp;tabindex=88' /> <input type='hidden' class='gform_hidden' name='is_submit_17' value='1' /> <input type='hidden' class='gform_hidden' name='gform_submit' value='17' /> <input type='hidden' class='gform_hidden' name='gform_unique_id' value='' /> <input type='hidden' class='gform_hidden' name='state_17' value='WyJbXSIsIjFmYmJkMmM5NDAyMGYzNTJmZGM3MmU0ODNlNDM2YjBmIl0=' /> <input type='hidden' class='gform_hidden' name='gform_target_page_number_17' id='gform_target_page_number_17' value='0' /> <input type='hidden' class='gform_hidden' name='gform_source_page_number_17' id='gform_source_page_number_17' value='1' /> <input type='hidden' name='gform_field_values' value='' /> </div> </form> </div> <iframe style='display:none;width:0px;height:0px;' src='about:blank' name='gform_ajax_frame_17' id='gform_ajax_frame_17' title='This iframe contains the logic required to handle Ajax powered Gravity Forms.'></iframe> <script type='text/javascript'>jQuery(document).ready(function($){gformInitSpinner( 17, 'https://posim.com/wp-content/plugins/gravityforms/images/spinner.gif' );jQuery('#gform_ajax_frame_17').on('load',function(){var contents = jQuery(this).contents().find('*').html();var is_postback = contents.indexOf('GF_AJAX_POSTBACK') >= 0;if(!is_postback){return;}var form_content = jQuery(this).contents().find('#gform_wrapper_17');var is_confirmation = jQuery(this).contents().find('#gform_confirmation_wrapper_17').length > 0;var is_redirect = contents.indexOf('gformRedirect(){') >= 0;var is_form = form_content.length > 0 && ! is_redirect && ! is_confirmation;var mt = parseInt(jQuery('html').css('margin-top'), 10) + parseInt(jQuery('body').css('margin-top'), 10) + 100;if(is_form){jQuery('#gform_wrapper_17').html(form_content.html());if(form_content.hasClass('gform_validation_error')){jQuery('#gform_wrapper_17').addClass('gform_validation_error');} else {jQuery('#gform_wrapper_17').removeClass('gform_validation_error');}setTimeout( function() { /* delay the scroll by 50 milliseconds to fix a bug in chrome */ jQuery(document).scrollTop(jQuery('#gform_wrapper_17').offset().top - mt); }, 50 );if(window['gformInitDatepicker']) {gformInitDatepicker();}if(window['gformInitPriceFields']) {gformInitPriceFields();}var current_page = jQuery('#gform_source_page_number_17').val();gformInitSpinner( 17, 'https://posim.com/wp-content/plugins/gravityforms/images/spinner.gif' );jQuery(document).trigger('gform_page_loaded', [17, current_page]);window['gf_submitting_17'] = false;}else if(!is_redirect){var confirmation_content = jQuery(this).contents().find('.GF_AJAX_POSTBACK').html();if(!confirmation_content){confirmation_content = contents;}setTimeout(function(){jQuery('#gform_wrapper_17').replaceWith(confirmation_content);jQuery(document).scrollTop(jQuery('#gf_17').offset().top - mt);jQuery(document).trigger('gform_confirmation_loaded', [17]);window['gf_submitting_17'] = false;}, 50);}else{jQuery('#gform_17').append(contents);if(window['gformRedirect']) {gformRedirect();}}jQuery(document).trigger('gform_post_render', [17, current_page]);} );} );</script><script type='text/javascript'> jQuery(document).bind('gform_post_render', function(event, formId, currentPage){if(formId == 17) {if(typeof Placeholders != 'undefined'){ Placeholders.enable(); }} } );jQuery(document).bind('gform_post_conditional_logic', function(event, formId, fields, isInit){} );</script><script type='text/javascript'> jQuery(document).ready(function(){jQuery(document).trigger('gform_post_render', [17, 1]) } ); </script>