All Questions
6
questions
0
votes
2
answers
139
views
Excel datetime format issue, possibly locale dependent
I'm working on a Belgian Excel 365 workbook. I have just imported a list of dates, looking like this:
dinsdag 5 december 2023 11:55:55
dinsdag 5 december 2023 11:55:56
dinsdag 5 december 2023 11:55:57
...
0
votes
0
answers
2k
views
Excel - paste *only* number formatting
Is it possible to copy/paste only number formatting in Excel.
There are various paste special options.
In particular Formulas/Number Formats and Values/Number Formats. But is there a way to paste only ...
0
votes
1
answer
139
views
How to output the results of 2 different cells into a single cell in Excel?
I am trying to get D5 and D6 into cell C6 so that I looks like this ($15,000.00 - $25,000.00) The formula I used to do this is :
=DOLLAR(D5)&" - "&DOLLAR(D6)
My first question is, ...
0
votes
1
answer
178
views
Number format #.# - Excel bug?
I try to use the number format #.# to display 7 as 7, but it does display "7." (in Excel, or other MS environment)
I want 7.1 to be 7.1, and 7 to be 7, and 7.49 to be 7.5, that is #.# (see ...
0
votes
1
answer
4k
views
How to change the formatting of German letters in Excel?
I have a CSV file with German words in its entries. Here's an excerpt:
As one can see, a number, a number of entries contain words with German words that contain characters that are depicted somewhat ...
0
votes
1
answer
2k
views
Excel apply complicated formula to existing cells value without copy/paste
I want to apply the formula
=TEXT(A1,IF(A1-INT(A1)=0,"0","#.####"))
to existing cells with numbers without doing copy and paste.
The existing spreadsheet is already big and ...