Numbers and Strings

Joined
Jun 1, 2014
Messages
1
Reaction score
0
Points
1
Hi I am using numbers and i what to use pop-up menu with roughly 3 - 5 prices per pop-up menu. I want to put a description next to the price so i remember what the price refers to. Here is an example



$15 basic food

$20 premium food



The problem i have is when i had text to the description it returns me an error message



The operator "*" expects a number, but the cell contains a string



Many thanks



Danny Kirk
 
Joined
Apr 26, 2008
Messages
2,963
Reaction score
120
Points
63
Location
Belgium
Your Mac's Specs
iPad Pro 12.9 latest iOS
I think you have to define the cell as " text " to achieve that, but than you may encounter issues when you use the cell for calculation.
You may need a bit of extra ' spreadsheet magic ' to use the cell for calculation.

Cheers ... McBie
 

Shop Amazon


Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.
Top