Date formating bug

J

Jim@HSC

How do you stop excel from automatically turning information in a range (like
8-12) to a date (August 12). This makes me so angry I can spit nails because
what should be a quick cut and paste becomes hours of extra work re-entering
the ranges excel automatically changes to dates with a leading ' to make it
text. Someone else has to have noticed this bug.
 
N

Nick Hodge

Jim

It's not a 'bug' it is a feature, 'by design'. It's great when you want it,
but a real pain when you don't. You can however pre-format the range as
text (Format>Cells>Number>Text) and that should get it to stick.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
S

setoFairfax

Try this;
BEFORE you paste, set the format of the cells you are going to paste to
as 'Text'. Then copy and paste. This should stop '8-12' from being
converted to 12-Aug.
 
F

Frank Kabel

Hi
not sure if one should consider this as a bug. Excel is in this case just
'too intelligent'. and maybe some users just expect this behaviour.
One easy solution: before entering these values preformat the range as 'Text'
 
Top