Hi
could you give an example for both values.
Normally using the 'General' format should do

--
Regards
Frank Kabel
Frankfurt, Germany
"Sarah" schrieb im Newsbeitrag
...
With a cell selected if you look at the formula bar it
shows a lot more text than you'd see by looking in the
cell itself. I've told it to wrap text; fit to size; copy
and paste into a new cell; copy and paste into a new
workbook- nothing works. What can I do to see the complete
cell contents on the worksheet and not just in the formula
bar?