Thread: How can I cap numbers in a column? (Workbook included)
View Single Post
 
Old 03-16-2020, 07:54 PM
appplejack007 appplejack007 is offline Windows 10 Office 2016
Novice
  
Join Date: Mar 2020
Posts: 6
appplejack007 is on a distinguished road
Default How can I cap numbers in a column? (Workbook included)
How can I set a limit for numbers before it goes to the next digit?

If you look at the workbook, Column B goes from 00.00.00 to 00.03.58 but I would like to have it 00.00.00 ... 00.03.39, then 00.04.00, 00.04.01, ... 00.04.39, 00.05.00 and so on.
By default as we all know that it goes like 00.00.00 ... 00.03.99 then 00.04.00 and so on.

How can I do this?

Thank you!!
Attached Files
File Type: xlsx Workbook.xlsx (22.0 KB, 12 views)
Last edited by appplejack007; 03-17-2020 at 03:23 PM.
Reply With Quote