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.

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

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.

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.

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