Automatic date changes

  • Thread starter Thread starter Jonathan Lowe
  • Start date Start date
J

Jonathan Lowe

When copying/pasting in excel, excel automatically
updates numbers like 3/3 or 2/6 into dates. Hwo do I stop
it doing this? as I would prefer it to just be '3/3
or '2/6 as a text.
Thanks
Jonathan
 
Jonathan,

like you mentioned in your post, you can force Excel to treat the numbers as
text by putting an apostrophe ' in front of the numbers. Alternatively, you
can format the cells as fractions (if this works for you) and then enter
your numbers and Excel will treat them as such and keep them as 2/6. Please
note that this won't work for 3/3 as Excel will convert this to 1. And just
to inundate you further (!) if it's just for asethetics, you could format
the cells with a custom format d/m and this would only show 3/3 rather than
3-Mar.

HTH,
Katherine
 
Jonathan,

Try formatting the destination cells using the Text number format. Then,
when pasting into those cells, use Paste Special and choose values. This
will not paste the formats, which would override the Text format you just
applied.
 
Back
Top