formatting

  • Thread starter Thread starter afdmello
  • Start date Start date
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
 
Very odd
Is this happening with only one cell?
What happens when you type say ABC123 in that cell
best wishes
 
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
 
Back
Top