All Questions
7
questions
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
2k
views
Conditionally formatting left align for a cell with text thats separated by multiple lines
I'm trying to write conditional formatting that will handle left aligning text in a cell that is normally in a range that's centered. The data in the cell could look like the following with each line ...
0
votes
4
answers
39k
views
Why does Excel add leading apostrophes to some of my text cells?
I have a worksheet containing, among other things, a table object. All data in the worksheet was added by me manually, including the data and column headers in the table.
I just noticed that in 13 of ...
0
votes
3
answers
2k
views
Excel text formatting function interpreting 'E' in string as exponent
I have exported some data records from a database into spreadsheet form for final formatting. One of the key fields is text in the form of '123456E72'.
I have a formatting formula that formats the ...
1
vote
0
answers
152
views
Create custom formatting for text fields in excel?
I have an issue in Excel and would like to create some custom formatting for a set of text fields. When I insert names into a spreadsheet, my source data often comes in with middle initials, surnames,...
2
votes
1
answer
2k
views
Formatting a tab-delimited CSV/TSV to force Excel to interpret value as a string
I had a followup question to this related post -
Formatting a CSV to force Excel to interpret value as a string (not date or number)
I was wondering how does one escape text starting with " using "...
135
votes
6
answers
326k
views
Formatting a comma-delimited CSV to force Excel to interpret value as a string
I've been searching around for a while trying to figure out how to output a CSV file in such a way to force Excel to interpret the values as a string and not try to convert them to numbers or dates.
...