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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formatting cells
##### means your column isn't wide enough for the data. ;-)
-- JoAnn Paules MVP Microsoft [Publisher] ~~~~~ How to ask a question http://support.microsoft.com/KB/555375 "Nospam" wrote in message . .. 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formatting cells
Oh--he said sheepishly. What about the formatting? Thanks. --Arthur
"JoAnn Paules [MVP]" wrote in message ... ##### means your column isn't wide enough for the data. ;-) -- JoAnn Paules MVP Microsoft [Publisher] ~~~~~ How to ask a question http://support.microsoft.com/KB/555375 "Nospam" wrote in message . .. 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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formatting cells
Sorry - I know enough about Excel to be dangerous. Publisher is my forte.
-- JoAnn Paules MVP Microsoft [Publisher] ~~~~~ How to ask a question http://support.microsoft.com/KB/555375 "Nospam" wrote in message ... Oh--he said sheepishly. What about the formatting? Thanks. --Arthur "JoAnn Paules [MVP]" wrote in message ... ##### means your column isn't wide enough for the data. ;-) -- JoAnn Paules MVP Microsoft [Publisher] ~~~~~ How to ask a question http://support.microsoft.com/KB/555375 "Nospam" wrote in message . .. 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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formatting cells
*PRE*-format the cells as text.
That means *before* you enter your numbers. When XL looks at numeric and general formatted cells that contain numbers, it's preparing for calculation, therefore the warnings that you're getting saying that something is not right. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Nospam" wrote in message ... Oh--he said sheepishly. What about the formatting? Thanks. --Arthur "JoAnn Paules [MVP]" wrote in message ... ##### means your column isn't wide enough for the data. ;-) -- JoAnn Paules MVP Microsoft [Publisher] ~~~~~ How to ask a question http://support.microsoft.com/KB/555375 "Nospam" wrote in message . .. 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 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formatting cells
So it's best to format the cells as text instead of general for my
purposes? --Arthur "Ragdyer" wrote in message ... *PRE*-format the cells as text. That means *before* you enter your numbers. When XL looks at numeric and general formatted cells that contain numbers, it's preparing for calculation, therefore the warnings that you're getting saying that something is not right. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Nospam" wrote in message ... Oh--he said sheepishly. What about the formatting? Thanks. --Arthur "JoAnn Paules [MVP]" wrote in message ... ##### means your column isn't wide enough for the data. ;-) -- JoAnn Paules MVP Microsoft [Publisher] ~~~~~ How to ask a question http://support.microsoft.com/KB/555375 "Nospam" wrote in message . .. 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 |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formatting cells
Format a couple of cells and try it ... you may like it!<g
It's your opinion that counts, based on what you see. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Nospam" wrote in message ... So it's best to format the cells as text instead of general for my purposes? --Arthur "Ragdyer" wrote in message ... *PRE*-format the cells as text. That means *before* you enter your numbers. When XL looks at numeric and general formatted cells that contain numbers, it's preparing for calculation, therefore the warnings that you're getting saying that something is not right. -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Nospam" wrote in message ... Oh--he said sheepishly. What about the formatting? Thanks. --Arthur "JoAnn Paules [MVP]" wrote in message ... ##### means your column isn't wide enough for the data. ;-) -- JoAnn Paules MVP Microsoft [Publisher] ~~~~~ How to ask a question http://support.microsoft.com/KB/555375 "Nospam" wrote in message . .. 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 |
Reply |
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) |