brightonpete
Departed
Rest in Peace
On a hike at Goodrich-Loomis
Posts: 5,110 
|
Post by brightonpete on Jul 26, 2018 20:11:29 GMT
It seems like most have PC's with Excel here, but are there any Apple users here? I'm re-vamping my Luxembourg spreadsheet in Apple's Numbers spreadsheet app. When I select a range of entries to count, I end up with a blue triangle as shown below... I searched in Preferences & online to see how to hide these, but have so far come up empty. Does anyone know? Perhaps I'll just have to put up with them. Oh well, at least I found out how to do that & didn't have to split one date field up into 3 text for the date! |
|
renden
Member 
Posts: 8,710
What I collect: World W collector with ++ interests in BNA (Canada etc) and USA
|
Post by renden on Jul 26, 2018 20:18:15 GMT
Though I respect people using a spreadsheet (in the Stamping world), I have my own on my private, paid, Stamp Program, when I want to see my inventory(ies).
I am a PC user, always will and will stay away from another type of computer since learning gets more cumbersome as you grow older ...hahahahah !! My Pc runs on Windows 7......and I stay away from "10" ...
René
cheers bpete !
|
|
brightonpete
Departed
Rest in Peace
On a hike at Goodrich-Loomis
Posts: 5,110
|
Post by brightonpete on Jul 26, 2018 20:30:02 GMT
I am a geek, what can I say, renden! I just checked on my iPad, and what do you know? No little blue triangle! I wish the iMac version of Numbers would be as accommodating as the iPad/iPhone versions are! |
|
Deleted
Deleted Member
Posts: 0
|
Post by Deleted on Jul 26, 2018 22:10:23 GMT
I don't use MS Excel anymore - Softmaker Office
but I remember that these triangles (come in different colors and locations) were some type of error checking warning. On the PC version in Options there was an "error checking" and you could uncheck the "Enable background error".
This may be in Mac?
|
|
zipper
Member
Posts: 2,649
What I collect: Classic GB, QV, France Ceres/Napoleon, Classic U.S., Cinderella & Poster Stamps
|
Post by zipper on Jul 26, 2018 23:04:53 GMT
Though I respect people using a spreadsheet (in the Stamping world), I have my own on my private, paid, Stamp Program, when I want to see my inventory(ies). I am a PC user, always will and will stay away from another type of computer since learning gets more cumbersome as you grow older ...hahahahah !! My Pc runs on Windows 7......and I stay away from "10" ... René cheers bpete ! Macs aren't difficult to learn to use. One can download a users guide from Apple. Once I got a Mac, I gave away my PCs. |
|
brightonpete
Departed
Rest in Peace
On a hike at Goodrich-Loomis
Posts: 5,110
|
Post by brightonpete on Jul 27, 2018 0:58:48 GMT
I don't use MS Excel anymore - Softmaker Office
but I remember that these triangles (come in different colors and locations) were some type of error checking warning. On the PC version in Options there was an "error checking" and you could uncheck the "Enable background error".
This may be in Mac?
It is just an explanatory note. It states, "The formula compares a number to a date." You'd think Apple would give you an option to hide them, because as you note, MS Excel does! I was thinking there was a way to do that, but it doesn't look like it, unless I use the iPad/iPhone versions. Or hey - it might be a "hidden" preference, which were prevalent in a number of apps of yore! |
|
brightonpete
Departed
Rest in Peace
On a hike at Goodrich-Loomis
Posts: 5,110
|
Post by brightonpete on Jul 31, 2018 15:39:15 GMT
After visiting the Apple support forum, problem solved.
Yay, no more blue triangles!
|
|
