6 replies
by anna.a.zelikman Accepted solution
by thumbsup2 Accepted solution
You might try typing all numbers as mentioned above with an appostrophe first to indicate that it IS text so that autoformat doesn't take over. Example
Instead of typing 6-10
type '6-10
The appostophe won't show in the cell, either looking at it or printing it. You won't see that it's even there unless you click into the cell itself and look at the formula bar.
Note: You don't have to format the whole spreadsheet as text. You can format JUST the column that you don't want to autoformat and leave the rest as they are. That way your numbers remain numbers (right aligned).
by anna.a.zelikman Accepted solution
by thumbsup2 Accepted solution
I saw the part in the first post that says you're copying and pasting... now you say you're getting the output from another program. I had assumed you were copying and pasting from another Excel spreadsheet.
Does your program have an export feature where you can save it as a comma or tab separated text file and then import that into the spreadsheet? During import, you can tell Excel what types of data are in each column (ie: text instead of a date).
by scott_heath Accepted solution
by scott_heath Accepted solution
This discussion is closed to new replies.
Trending Software posts
Sort by Trending