New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
Apple Desktops Discussion of Apple's desktop machines including Mac Pro, iMac, Power Mac, and mini

Numbers and Strings


Post Reply New Thread Subscribe

 
Thread Tools
dannytype1

 
Member Since: Jun 01, 2014
Posts: 1
dannytype1 is on a distinguished road

dannytype1 is offline
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
QUOTE Thanks
McBie

 
McBie's Avatar
 
Member Since: Apr 26, 2008
Location: Belgium
Posts: 2,290
McBie is a name known to allMcBie is a name known to allMcBie is a name known to allMcBie is a name known to allMcBie is a name known to allMcBie is a name known to allMcBie is a name known to all
Mac Specs: 2013 MBA 13" - 10.9.3 & iPad - iOS 5.1

McBie is offline
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

A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila.
The problem is not the problem. The problem is your attitude towards the problem. You understand ?
QUOTE Thanks

Post Reply New Thread Subscribe


« Replacement for 24" White iMac | Mac Voice Recognition »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

All times are GMT -4. The time now is 02:51 PM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?