All Questions
8
questions
67
votes
11
answers
263k
views
Excel copy-paste: always match destination formatting
I use Excel to crunch numbers, so I usually don't want to copy the formatting along with the text. But this is the default. Is there a way to default to always match destination formatting when ...
1
vote
1
answer
754
views
In Excel how can I replace 6 Zeros with an M?
For example,
How do I turn $200 000 000 to $200 M.
How do I turn $12 500 000 to $12.5 M?
I use Excel 2013.
0
votes
1
answer
81
views
Excel 2013 fails to record macro correctly
So, i want to create a macro that will set selected cells' format to 0,0 ¥.
However, if you record the steps and then try to run the macro it will set format to 0,0 ?. Is there a way to fix this?
0
votes
1
answer
358
views
How to transform this "7.33E+11" to a standard number (i.e. UPC code)
I have a difficulty with transforming this 7.33E+11
in Excel. I had many rows with 6,22357E+11 which I can easily transform to number and it is all fine, but what happens with the one with the "." ...
0
votes
0
answers
54
views
In MS Excel Is there any way to use number formatting on entries with a mix of letters and numbers?
I'm trying to decimal justify a list using the number formatting, but the numbers in question happen to have letters in them, and they're being ignored. Is there any way to get Excel to recognize ...
0
votes
1
answer
1k
views
How do I insert thousands-separators without affecting significant figures in Excel?
I need to figure out how to add thousands separators to large spreadsheets without affecting the amount of significant figures or the dates that are also in the tables. I can't figure out how to use ...
0
votes
0
answers
1k
views
How to change the colours of sparkline axes individually
I found the following code (in the office docs) which allows me to change the axis colour of a group of sparklines:
Sub AxisColor()
'The sparkline group
Dim oSparkGroup As SparklineGroup
'...
-1
votes
2
answers
246
views
MS excel not coping data in correct format from csv file
I am coping data from csv file
it contains tables
in that table there is column name PostedDate
when i copy that PostedDate column in excel it shows wrong formatting (ie instead of / it shows -)
...