def format_string(value):
    """Formatting utility to parse spreadsheet cell values"""
    if value.lower() == 'false':
        return False
    if value.lower() == 'true':
        return True
    try:
        value = float(value)
        if int(value) == value:
            value = int(value)
    except ValueError:
        pass
    return value
