Yes, this happens because the destination cell(s) have a different format than the source cell(s). When you copy and paste values from one sheet to another, Excel tries to match the format of the source cell(s) with the destination cell(s). If the formats don't match, Excel may offer you different paste options, such as "text" or "Unicode text".

To avoid this, you can try changing the format of the destination cell(s) to match the format of the source cell(s) before pasting. Here's how:

1. Select the destination cell(s) where you want to paste the values.
2. Press Ctrl+1 to open the Format Cells dialog box.
3. In the Number tab, select the same format as the source cell(s). For example, if the source cell(s) are formatted as "General", select "General" in the Number tab.
4. Click OK to close the dialog box.
5. Now you can copy and paste the values from the source sheet to the destination sheet using Paste Special and Values.

If you still see the "text" or "Unicode text" options, it may be because the source cell(s) contain text or special characters that cannot be converted to the destination format. In this case, you can try using the "text" or "Unicode text" option to paste the values as plain text, without any formatting.