Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formatting cells
I'm using Excel 2002. I've created a spreadsheet of my weightlifting
workouts--dates, exercises, and in the cells, the number of sets I perform with the number of repetitions. For instance, cells have numbers like 2-12, 2-9, 3-12, indicating two or three sets of 9 or 12 repetitions. The problem is that I'm formatting the cells as general, but I'm still getting a green triangle in the upper left cell corner, and when I hold the cursor over the cell, the yellow exclamation point appears, asking me if I want to ignore the formatting error. In some cells that I think I've already formatted, my numbers turn to "###." I want to enter the numbers as plain text with no other formatting. What am I doing wrong? Also, what's the formatting difference between "general" and "text" formatting? Thanks. --Arthur |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
Excel should allow more options for formatting cells | Excel Worksheet Functions | |||
How to copy "edge" formatting to other cells. | Excel Discussion (Misc queries) | |||
Cells losing formatting | Excel Discussion (Misc queries) |