All Questions
6
questions
0
votes
2
answers
172
views
Prevent Excel from autocalculating Fractions when using Find and Replace
I am trying to replace data formatted like this:
##"/##"
(see this picture via link for example:
Before find-and-replace text)
using find-and-replace to find every quotation mark ( " ) ...
1
vote
2
answers
64
views
Break hours by minutes instead of decimals when formating a cell, but keeping the formula intact. Is that possible?
I recently used this formula for time calculation within one cell and it worked great!
But I remained with a top up question: Is there a way to allow breakdown hours?
For example, using this:
9pm - 4:...
1
vote
2
answers
2k
views
How to convert negative decimal to negative time in excel and show it
I'm creating a spreadsheet for dispatch staff to track how far ahead/behind they are of schedule.
Columns C4-16, E4-16 and F4-16 are lists
D4-16 & G4-16 are converting the time from there adjacent ...
2
votes
1
answer
72
views
What formula in macro can I use to show a value as dd:hh:mm, exceeding 31 days?
When using the format for dd:hh:mm Excel gives us, it is not possible to show an amount of days greater than 31.
Using the following formula in macro is not possible
=INT(C5)&":"&TEXT(C5,"...
0
votes
2
answers
5k
views
MS Excel - limiting the number of decimal places to which you are able to manually enter
I have to enter values manually into an Excel sheet for use in calculations. The trouble is, because the column I am entering into is formatted to only show to 2 decimal places, if I accidentally add ...
2
votes
2
answers
516
views
How can I custom format in excel to place periods (as separators) in an 18 digit entry?
This is regarding 18-digit accounting codes that contain multiple periods, as separators. I would like to enter just the digits without typing in the periods. Example:
112233333444555556
would ...