|
|
#1
03-16-2020, 07:54 PM
|
|||
|
|||
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!! Last edited by appplejack007; 03-17-2020 at 03:23 PM. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I copy a workbook to another workbook and keep the formatting within the new workbook | excelforsue | Excel | 3 | 09-15-2020 03:37 AM |
| Best formula for matching column data from one workbook into another | awpatts | Excel | 1 | 05-10-2017 06:56 AM |
| automatically copy FIRST COLUMN ONLy to all sheets in workbook | nrcahill | Excel | 1 | 03-14-2016 12:26 PM |
| Copy Column setting to other spreadsheets in an excel workbook | officeboy09 | Excel | 5 | 11-05-2013 01:49 AM |
 Spliting column with text and numbers
|
mjosic | Excel | 3 | 04-04-2012 05:56 AM |
Windows 10 
Office 2016
Threaded Mode