On Nov 16, 2007 10:03 PM, 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. > > Regards > > Steve H. > > Have you tried using the "paintbrush" tool, to copy formats without copying cell contents? It sounds like you are copying the dates (numeric value) themselves down but just want to copy the format. -- Johnviestenz
