formatting

A

afdmello

XL 2007

I have a cell that indicates '1' the ribbon shows formatting as general.
However when I click in the cell the formula bar shows SW18756489 and when I
double click inside the cell also SW18756489 is shown and I can edit it. How
can make the cell indicate SW18756489.

AFD
 
B

Bernard Liengme

Very odd
Is this happening with only one cell?
What happens when you type say ABC123 in that cell
best wishes
 
A

afdmello

I did not type anything into it(no time) I will try tomorrow but what is
strange is it is displaying the digit 1; the formatting is general and when
I single click the cell it is displaying what I want in the formula bar.

Afd
 
Top