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