Automatic formatting upon find/replace

  • Thread starter Thread starter Aaron
  • Start date Start date
A

Aaron

I have a problem that I keep getting...

I have cells with dates ranges like "2002-03" (with no quotes). The
cells are formatted to text. When I do a find/replace for "20" in order
to make the result "02-03", all of the cells are automatically
autoformatted again to dates (apparently), resulting in "3-jan" in each
cell. How can I get around this annoyance?

Thanks,
Aaron
 
You could try:
Edit|replace
20
with
' (single quote)

but if you have
2002-20
you'll end up with
02-'

I'd do a series of replaces:
2000
with
'00

2001
with
'01

etc.

======
Actually, if these were really dates, I'd use a custom format:

yy-mm
(they represented years and months?)
 
Back
Top