Excel - CSV file, trying to save a date as text, reverts back to d
I've downloaded a csv file from bank. The date needs to be in MM/DD/YYYY. I
type in in as text 01/01/2007 but when I save it it reverts back to date format. |
Excel - CSV file, trying to save a date as text, reverts back to d
With date in A1
In B1 enter =TEXT(A1, "MM/DD/YYYY") Double-click on the fill handle to increment down. CopyPaste SpecialValues and delete column A Gord Dibben MS Excel MVP On Fri, 9 Feb 2007 12:21:01 -0800, Rick Sully <Rick wrote: I've downloaded a csv file from bank. The date needs to be in MM/DD/YYYY. I type in in as text 01/01/2007 but when I save it it reverts back to date format. |
All times are GMT +1. The time now is 10:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com