software

When you type in 5/2, I know Excell will automatically convert it to 02-May.
I know I can change the formatting of the cell, up to even using a mask. How
do I get content I paste (i.e. from a site displaying data in a grid format),
to NOT convert fractions to dates? Changing the content of the data from a
website is not an option.

Perhaps try pre-formatting the cell(s) / col as Text before copy gt; pasting
(via: Format gt; Cells gt; Number tab gt; Text gt; OK)
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Stephaniequot; gt; wrote in message
...
gt; When you type in 5/2, I know Excell will automatically convert it to
02-May.
gt; I know I can change the formatting of the cell, up to even using a mask.
How
gt; do I get content I paste (i.e. from a site displaying data in a grid
format),
gt; to NOT convert fractions to dates? Changing the content of the data from
a
gt; website is not an option.
Pre-formatting the cells did not work. I had tried that. I guess the
quot;pastingquot; overrides the cell format.

quot;Maxquot; wrote:

gt; Perhaps try pre-formatting the cell(s) / col as Text before copy gt; pasting
gt; (via: Format gt; Cells gt; Number tab gt; Text gt; OK)
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt; quot;Stephaniequot; gt; wrote in message
gt; ...
gt; gt; When you type in 5/2, I know Excell will automatically convert it to
gt; 02-May.
gt; gt; I know I can change the formatting of the cell, up to even using a mask.
gt; How
gt; gt; do I get content I paste (i.e. from a site displaying data in a grid
gt; format),
gt; gt; to NOT convert fractions to dates? Changing the content of the data from
gt; a
gt; gt; website is not an option.
gt;
gt;
gt;

quot;Stephaniequot; wrote
gt; Pre-formatting the cells did not work. I had tried that.
gt; I guess the quot;pastingquot; overrides the cell format.

How about paste special gt; text ?
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---