Thread
:
Date-error Format
View Single Post
#
1
Posted to microsoft.public.excel.setup
Mia
external usenet poster
Posts: 101
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
Reply With Quote
Mia
View Public Profile
Find all posts by Mia