G Guest Nov 20, 2006 #1 I input PPTED1 in a cell, but it just shows the last character 1 in print preview. Please help. Thank you.
I input PPTED1 in a cell, but it just shows the last character 1 in print preview. Please help. Thank you.
G Guest Nov 21, 2006 #2 Try selecting the cell, going to format and choosing a TEXT format. This should not alter what you're entering atall. Keep us posted
Try selecting the cell, going to format and choosing a TEXT format. This should not alter what you're entering atall. Keep us posted
G Guest Nov 22, 2006 #3 Sorry, I am not able to try yours as the actual situation is no longer available. My colleague has rectified it by removing the word wrap and widening the cell. I will give your solution a try if I encounter the same situation next time. Thank you.
Sorry, I am not able to try yours as the actual situation is no longer available. My colleague has rectified it by removing the word wrap and widening the cell. I will give your solution a try if I encounter the same situation next time. Thank you.