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

When I click on the link, it says this page is not found.

"James Silverton" wrote:

Hello, Kelly!
You wrote on Thu, 28 Sep 2006 11:25:02 -0700:

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

There may be better ways to do it, but what I would do us to
copy the cell in the fraction format, use PureText to remove
programmatic material and then paste. It does work and PureText
is free as I mentioned in another context recently.

The PureText free utility: http://www.stevemiller.net/puretext/


James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not