Yes, that's correct: the value might be "1" but the number formatting displays this value as "A-101".To convert the formatted number into a string that contains the formatting simply save your spreadsheet as a .txt file, close it and reopen the text file. You will see the value is now "A-101".