Thread: Numbers and Strings
06-01-2014, 05:30 AM #1
Numbers and Strings
- Member Since
- Jun 01, 2014
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
06-01-2014, 10:44 AM #2
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 ... McBieA computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila.
The bitterness of poor quality remains long after the sweetness of low price is forgotten.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Yodda_Hunter in forum OS X - Development and DarwinReplies: 0Last Post: 05-05-2014, 06:49 PM
By Yodda_Hunter in forum OS X - Development and DarwinReplies: 3Last Post: 02-07-2014, 03:08 PM
By MartinS in forum Schweb's LoungeReplies: 24Last Post: 07-07-2007, 12:01 AM
By feanor in forum OS X - Operating SystemReplies: 1Last Post: 10-13-2005, 12:59 PM