In article <[EMAIL PROTECTED]>, Stephen Hamburger <[EMAIL PROTECTED]> wrote:
> Greetings, > > I'm using v2.3 of the "calc" program...I have data loaded into the > application that includes dates. The format on import is DD/MM/YY. > When I change this to YYYYMMDD in the function area, everything is fine > until I click and drag down to apply the format to all the remaining > lines...what happens is that the last 2 digits are re-numbered in > sequential order (i.e. 02,03,04,05,...) automatically...how is it > possible to shut this off? I do not want the numbers altered in any > way. I just want to format the date properly. Thank you in advance. There are certainly better ways of applying formatting which no doubt others will cover. However, to prevent the behaviour you are complaining of hold down the Ctrl key as you drag. R -- Richard Travers [EMAIL PROTECTED] Truro, Cornwall --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
