[NFBCS] Making dates all same length in Excel
Tracy Carcione
carcione at access.net
Tue Mar 7 14:21:51 UTC 2023
Thanks. That was exactly what I needed, and now I know how to do it.
Tracy
From: NFBCS [mailto:nfbcs-bounces at nfbnet.org] On Behalf Of Dr Denise M Robinson via NFBCS
Sent: Tuesday, March 07, 2023 8:32 AM
To: NFB in Computer Science Mailing List
Cc: Dr Denise M Robinson; Tracy Carcione
Subject: Re: [NFBCS] Making dates all same length in Excel
Tracy
Applications key on the cell and you land in number of the format cells dialog, go down to date and tell it what you want. Select all cells that you want before you apply the format
Denise M Robinson
Denise M Robinson, TVI, AT, IT, PhD, CEO
425-220-6935
Teaching Technology and instruction that gives you Vision
www.yourtechvision.com
YouTube Channel with hundreds of lessons for blind skills <https://www.youtube.com/channel/UC7YW7Ves0phCwCOtaZ3wWFw> on the computer and more <https://www.youtube.com/channel/UC7YW7Ves0phCwCOtaZ3wWFw>
Specialist-Technology/Blind Skills | Teacher of the Blind and Visually Impaired
425-220-6935 | www.yourtechvision.com
“We cannot solve our problems with the same thinking we used when we created them.” --Albert Einstein
Image removed by sender. TechVision Logo
“Helping the visually impaired see their world changed through technology”
"While they were saying among themselves it cannot be done, it was done." --Helen Keller
On Tue, Mar 7, 2023 at 7:44 AM Tracy Carcione via NFBCS <nfbcs at nfbnet.org> wrote:
Does anyone know how to make all dates the same length in Excel, so that, when I convert an Excel file to .csv or some other format, the delimitors are all in the same place?
For example, I want 2/4/2023 to come out as 02/04/2023, so that the delimitor is in the same place as it is for 11/25/2022.
Thanks.
Tracy
_______________________________________________
NFBCS mailing list
NFBCS at nfbnet.org
http://nfbnet.org/mailman/listinfo/nfbcs_nfbnet.org
To unsubscribe, change your list options or get your account info for NFBCS:
http://nfbnet.org/mailman/options/nfbcs_nfbnet.org/deniserob%40gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://nfbnet.org/pipermail/nfbcs_nfbnet.org/attachments/20230307/44879458/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 422 bytes
Desc: not available
URL: <http://nfbnet.org/pipermail/nfbcs_nfbnet.org/attachments/20230307/44879458/attachment.jpg>
More information about the NFBCS
mailing list