• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Troubleshooting

Stopping Automatic Conversions

Q1:After importing data into a worksheet from text files and databases, I noticed that Excel converts some data to date serial values and other data to scientific notation. I want the information to appear in my worksheet exactly as it did in the database. Is there any way to change it back?
A1: No, unfortunately. When Excel sees a value that looks like a date or time or scientific notation, either when you type a value into a cell or when you import a database, it converts the value automatically as you type or import. There is no way to reverse this conversion. If you have serial numbers that use the format ##X####, where each # is a number and the X is a letter, Excel converts any serial number that contains the letter E in that position to scientific notation. Your best option is to edit the text or database file, adding an apostrophe to the beginning of each field that contains values Excel will try to convert. In that case, Excel imports the data in text format exactly as it appears.

Click Twice for Normal

Q1:I formatted text in a cell using more than one font, and I want to restore Excel's default font format. I opened the Format Cells dialog box, clicked the Font tab, and checked the Normal Font box once, but my formatting stays exactly as it was. What's the secret?
A1: When you have multiple font formats applied to different words or characters in a cell, the Normal Font check box is checked, but it's grayed out. To restore the default formatting, click once to clear the box (exactly the opposite of what you normally do), and then click OK to close the dialog box. Now reopen the dialog box and check the Normal Font box again. This time your change will stick.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint