what is the geen triangle in a cells with number?

  • Thread starter Thread starter bigcitydave
  • Start date Start date
B

bigcitydave

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.
 
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.
 
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".
 
Are these cell formatted as text..Right click>FormatCells> to see in which
format they are,

To convert to numbers; copy a blank cell> select the range>Right click
Pastespecial>check Add>click ok
Click to expand...

If this post helps click Yes
 
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.
 
Back
Top