Auto Correct

[Guest]

I am trying to label a column as 12/33 or 12 over 33 and excel keeps changing
the tag to Dec - 33 as in a date. How do I remove auto fix for this cell so
I can depict my divisor problem?

 

[Pete_UK]

Put an apostophe in front of it if you want it to be a label, or pre-
format the cell as Text. If you want it to be a value then put an
equals sign in front.

Hope this helps.

Pete

 

[Guest]

I fixed the problem by formatting the cell as "text."

 

[Pete_UK]

Told you so ... <bg>

Pete

I fixed the problem by formatting the cell as "text."





- Show quoted text -