Thread: Cell Format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kelly Kelly is offline
external usenet poster
 
Posts: 132
Default Cell Format

Is there any way for me to paste what visibly shows in a cell to what the
data actually is? I have a cell that shows 1101 3/25. It is formatted as a
fraction. In the formula bar, the data shows 1101.12. What I really want is
for the data to be text and show 1101 3/25.

Thansk!