All Questions
Tagged with format microsoft-excel
96
questions
0
votes
1
answer
41
views
How to change from 3.023.842.96 to the format of 3,023,842.96 and I would like to able to sum the numbers too. Thank you
How to change from 3.023.842.96 to the format of 3,023,842.96 and I would like to able to sum the numbers too. Thank you
0
votes
2
answers
74
views
How to avoid values turning to a Scientific format when text contains 'E' followed by a number?
I am trying to open an excel file that has a column containing different barcodes. These barcodes have the following format:
4820001E1
4820001E2
4820002E1
4820002E2
However, when I open the file, the ...
0
votes
1
answer
44
views
Excel: Custom format of date that excel cannot notice
My problem looks like this:
Dec 8, 2022, 8:35:04 AM
I need to let excel see this format as. I tried date to columns option, it didn't work. I did it in like 10 steps. Can it be done any simpler by ...
0
votes
0
answers
256
views
Hide row in excel and maintain table format
I'm hidding a row using VBA when a cell is selected.
The problem is that when I hide the row the colors of the table format mess up.
Any way to keep the table format updated when hidding a row?
Thanks ...
0
votes
0
answers
42
views
How to randomize sensitve numerical data in Excel while maintaining existing data format(s) for public post? RAND each digit each cell
How to randomize sensitve numerical data in Excel while maintaining existing data format(s) for public post? This is to supply Technical Support all information (format, shape ) except confidential ...
0
votes
0
answers
273
views
VBA , if then statement with data and color change
I am using an if then statement to change value of cell to "test' if true. I also want to change fill color if changed
Then Cells(myRows,"AB") = "Test" ( how do I add fill in ...
0
votes
2
answers
171
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 ( " ) ...
0
votes
2
answers
261
views
Excel format numbers so there is space after second number
I am working with 5 and 6 digit numbers, 2 + 3(4) (maybe +5 in the future, like 22 123 or 22 1234). I must write these numbers without space and want it to be formated with space. Simple enough, I ...
1
vote
0
answers
457
views
Excel previously changed text to dates. How do I get it back to what I originally typed?
I have a large Excel (xlsx) spreadsheet full of various types of data. I had initially downloaded this data from Google Sheets. At some point (I'm not sure when), one of my columns of data that had ...
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:...
0
votes
1
answer
488
views
Is it possible to hide both value AND percentage in the label of an Excel chart when the value is 0?
We use both the value and percentages in the label of our charts, and I would like to know if there is a way to hide both when the value is 0. I understand how to hide it with the number format code ...
2
votes
2
answers
3k
views
In Excel, how can I round or display numbers to 2 significant figures (the two leading non-zero digits of a decimal number)?
In Excel 2016 I need to show zeros out to the leading non-zero digits and then just the two digits after that. For example:
0.00002423 should read 0.000024,
0.242 should read 0.24,
0.0032255 ...
0
votes
3
answers
10k
views
How do you search for a specific date in excel?
Whenever I search for a date in excel using Ctrl+F, it never works. I've tried searching for a date using the displayed format, ie. 2020-12-31 and even though I can see the date in the column, excel ...
0
votes
2
answers
78
views
EXCEL Substracting date Thu 11 Feb 2021 - 02:00 and hours (ex:4) gives error
I need to calculate cutoffs to get the final time a truck departs from a node. Here below an example:
Thu 11 Feb 2021 - 02:00 - 4 ( Warehouse process Hours) = ERROR
I would like to manipulate ...
0
votes
1
answer
626
views
Excel sequential dates with gaps
I am trying to create a backup for my timesheet in Excel because I work in several different departments. I need to do a run of seven dates, a space, run of another seven dates, followed by three ...