Marcelo Branco
MrExcel MVP
- Joined
- Aug 23, 2010
- Messages
- 16,371
Well, i looked at the data, looked again, and I saw no zero in data ...
(just kidding, 999 is safer of course)
Thank you for the reply.
M.
-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
Rearranging Data in Excel
Well, i looked at the data, looked again, and I saw no zero in data ...
(just kidding, 999 is safer of course)
Thank you for the reply.
M.
Some videos you may like
Excel Facts
Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
sandy666
Well-known Member
- Joined
- Oct 24, 2015
- Messages
- 5,047
I used 999 because it's taken from my nick and turned upside downWell, i looked at the data, looked again, and I saw no zero in data ...
(just kidding, 999 is safer of course)
Have a nice day
Watch MrExcel Video
Forum statistics
Share this page
This Week's Hot Topics
-
problem function date add into datepicker on userform
- Started by abdelfattah
- Replies: 48
hi i have problem add years and months days is ok i have textbox1= days textbox2= months textbox3= years when i... -
Vlookup Help
- Started by tomehta
- Replies: 39
Hello In attached excel screen shots, in Col I (sheet 1), I want Col C value (from sheet 2), similarly in Col P (sheet 1) want Col D value( from... -
Split cells based on specific text which may occur multiple times in cell
- Started by charlie_580
- Replies: 25
Hi I wonder if anyone can help? I need to split multiple cells by code, however the code may occur within the original cell more than once. and... -
AVERAGE RANGE CELLS DD:HH:MM FORMAT
- Started by LawNapier
- Replies: 25
I am trying to average the below in DD:HH:MM format. The cells format is set as "custom > DD:HH:MM". I want to only average the time for the... -
Need to color specific cells on another sheet automatically
- Started by csteps
- Replies: 23
Need the cells listed in yellow to color those cells on another sheet automatically [ATTACH type="full"]14354[/ATTACH] -
Move Files To Dynamic Folders Based On Cell Value
- Started by wells
- Replies: 22
Im not sure this is still possible... I referred few posts but they dont work with current office edition.. I have a folder with say around 100...