Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the geen triangle in a cells with number?
A green triangle appears in each cell in a row of numbers and I can't use
autosum. It's like it doesn't recognize it as a number. This spreadsheet was generated in Windows98, and transfered to Windows Vista Home Premium 64-bit but the same green triangle also appeared in Windows98. Can't find anything in formating a cell. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the geen triangle in a cells with number?
It's not the version of windows that matters--it's the version of excel.
And newer versions of excel (xl2002 and later, I think) have an indicator for possible errors. You can look under: Tools|Options|error checking tab to see the things that excel will check for you--and you can turn off the ones you don't want. bigcitydave wrote: A green triangle appears in each cell in a row of numbers and I can't use autosum. It's like it doesn't recognize it as a number. This spreadsheet was generated in Windows98, and transfered to Windows Vista Home Premium 64-bit but the same green triangle also appeared in Windows98. Can't find anything in formating a cell. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the geen triangle in a cells with number?
My best guess is that you have a number stored as text (which is what the
green flag is warning you about). This would also explain why you can't get a sum, as the sum of text = 0. Quick way to convert numbers: Place a 1 into a cell somewhere. Copy cell. Select cells with numbers stored as text. Right-click, paste special. Choose "multiply". -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "bigcitydave" wrote: A green triangle appears in each cell in a row of numbers and I can't use autosum. It's like it doesn't recognize it as a number. This spreadsheet was generated in Windows98, and transfered to Windows Vista Home Premium 64-bit but the same green triangle also appeared in Windows98. Can't find anything in formating a cell. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the geen triangle in a cells with number?
Are these cell formatted as text..Right clickFormatCells to see in which
format they are, To convert to numbers; copy a blank cell select the rangeRight click Pastespecialcheck Addclick ok If this post helps click Yes --------------- Jacob Skaria "bigcitydave" wrote: A green triangle appears in each cell in a row of numbers and I can't use autosum. It's like it doesn't recognize it as a number. This spreadsheet was generated in Windows98, and transfered to Windows Vista Home Premium 64-bit but the same green triangle also appeared in Windows98. Can't find anything in formating a cell. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the geen triangle in a cells with number?
And if you want to convert those text numbers to real numbers, let excel's
warning help. Select the range to fix (make sure the activecell has that warning), click on the warning icon and choose convert to number. Dave Peterson wrote: It's not the version of windows that matters--it's the version of excel. And newer versions of excel (xl2002 and later, I think) have an indicator for possible errors. You can look under: Tools|Options|error checking tab to see the things that excel will check for you--and you can turn off the ones you don't want. bigcitydave wrote: A green triangle appears in each cell in a row of numbers and I can't use autosum. It's like it doesn't recognize it as a number. This spreadsheet was generated in Windows98, and transfered to Windows Vista Home Premium 64-bit but the same green triangle also appeared in Windows98. Can't find anything in formating a cell. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
red triangle | Excel Discussion (Misc queries) | |||
Red triangle | Excel Worksheet Functions | |||
How can cells be changed from rectangle to triangle in Excel? | Excel Discussion (Misc queries) | |||
Purple Triangle | Excel Discussion (Misc queries) | |||
I am getting Green triangle on one column in all the cells ? | New Users to Excel |