It seems you store room numbers as numbers, this case LEFT is not the best choice, isuse INT instead:
=INT(A2/100)
To keep the leading zero (04 instead of 4) you need to set number format of the cells to "Custom" with "type": 00
Thanks @fixer1234 for the comment!
It seems you store room numbers as numbers, this case LEFT is not the best choice, is INT instead:
=INT(A2/100)
To keep the leading zero (04 instead of 4) you need to set number format of the cells to "Custom" with "type": 00
Thanks @fixer1234 for the comment!
It seems you store room numbers as numbers, this case LEFT is not the best choice, use INT instead:
=INT(A2/100)
To keep the leading zero (04 instead of 4) you need to set number format of the cells to "Custom" with "type": 00
Thanks @fixer1234 for the comment!
It seems you store room numbers as numbers, this case LEFT is not the best choice, is INT instead:
=INT(A2/100)
To keep the leading zero (04 instead of 4) you need to set number format of the cells to "Custom" with "type": 00
Thanks @fixer1234 for the comment!
It seems you store room numbers as numbers, this case LEFT is not the best choice, is INT instead:
=INT(A2/100)
It seems you store room numbers as numbers, this case LEFT is not the best choice, is INT instead:
=INT(A2/100)
To keep the leading zero (04 instead of 4) you need to set number format of the cells to "Custom" with "type": 00
Thanks @fixer1234 for the comment!
