View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
Mia Mia is offline
external usenet poster
 
Posts: 101
Default Date-error Format

I´m trying to do a sheet make o new date format. The new format should be
yyyymmdd. I have 2008-07-01 (yyyy-mm-dd), but it responds 20080001.
The formula I´m using are =TEXT(cell; "ååååmmdd"), do anyone know what´s
wrong?

BR
Mia