ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How can I setup a date without the slashes moving in a worksheet? (https://www.excelbanter.com/excel-programming/342043-how-can-i-setup-date-without-slashes-moving-worksheet.html)

TT

How can I setup a date without the slashes moving in a worksheet?
 
After creating a worksheet with the date in it, when entering the date, how
do you prevent the slashes from moving?

K Dales[_2_]

How can I setup a date without the slashes moving in a worksheet?
 
Prevent slashes from moving meaning after date is entered you always want
them in the same place horizontal location within the cell? Using standard
date format such as "mm/dd/yyyy" keeps slashes aligned in same place, but
means you need to show leading zero. Do you need to do something different
than that?
--
- K Dales


"TT" wrote:

After creating a worksheet with the date in it, when entering the date, how
do you prevent the slashes from moving?



All times are GMT +1. The time now is 05:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com