Import Existing Plans/Subscribers

12 years 7 months ago #95281 by trlbldr
Replied by trlbldr on topic Re:Import Existing Plans/Subscribers
Thanks to all who responded! Your assistance is invaluable.

Cheers.

Don White

Please Log in to join the conversation.

12 years 6 months ago #99303 by Aly
Replied by Aly on topic Re:Import Existing Plans/Subscribers
attempting to paste in: 2009-01-01 00:00:00 in OOCalc converts to different date format.

How do I make it accept my "plain text" entry without converting to: 01/01/09 12:00AM

Please Log in to join the conversation.

12 years 6 months ago #99420 by 3cellhosting
Replied by 3cellhosting on topic Re:Import Existing Plans/Subscribers
Hi Aly,

I highlighted the cell, then selected Format > Cells and picked the date shown as 1999-01-01

This opens the formatter at the bottom of the pop-up and shows the format as YYYY-MM-DD and all I did was added a space then HH:MM:SS and this converted the cell to match the required format of 1999-01-01 00:00:00

I then used the format brush to copy that format to the rest of the date cells.

I then saved as a csv file.

All worked fine.

Hope this helps.

David

David
www.3cellhosting.com - where personality, creativity and integrity come as standard.

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.215 seconds

Facebook Twitter LinkedIn