Description

This article is from the Spreadsheets FAQ, by Russell Schulz casfaq@locutus.ofB.ORG with numerous contributions by others.

10.11 I get odd (square?) characters where I expect commas (thousands) or slashes (dates). What happened? (spreadsheets: Excel)

check your International settings in Control Panel. when these get
corrupted, Excel will still use them, with ugly results.

10.12 How can I add 14:00 to 14:00 and get the cell to say 28:00 instead of 04:00? (spreadsheets: Excel)

> For Excel 5, 7, 8
> format the cell: [h]:mm
>
> Excel 97 makes it easier now, by including the format among the pull
> down choices for a time format.

 

Continue to:

• prev: 10.9 Any number I type in gets divided by a power of 10. Why? (spreadsheets: Excel)
• Index
• next: 10.13 Why is =-1^2 positive and =0-1^2 negative? (spreadsheets: Excel)

Share and Enjoy

Tags

business, spreadsheets, Excel, Quattro, Lotus 1-2-3, free, open source, commercial, tab delimited, csv, formula, macro