Display as a Number

[rgz]

I want to display '2+' in some cells on my spreadsheet and have excel use this as '2' for the purposes of calculations. How do I format the 2+ cell to accomplish this?

[adhawan06]

Hi rgz,

Welcome to the forum.

Excel will not consider as number and will not calculate if you have entered anything by '. Can you explain your purpose and also for the same, kindly upload the attachment

[Glenn Kennedy]

Can I ask a silly question? Why?

Anyway... format as # +

Also, welcome to the Forum.

[adhawan06]

Hi rgz,

Welcome to the forum.

Excel will not consider as number and will not calculate if you have entered anything by '. Can you explain your purpose and also for the same, kindly upload the attachment

[rgz]

Hi rgz,

Welcome to the forum.

Excel will not consider as number and will not calculate if you have entered anything by '. Can you explain your purpose and also for the same, kindly upload the attachment

The ' is mentioned just to separate it from the text in my post. It isn't used on the formula cell. I'm not able to share my sheet.

[rgz]

Because I need to indicate the number is >2 but need to 2 for the purposes of my calculations.

[rgz]

Anyway... format as # +

This worked, thanks!

[adhawan06]

Hi rgz,

Thanks to Glenn Kennedy (Our expert) has solved your query. Also, its very easy to share your file. Click on "Go Advance" and then click on paperclip sign to attach / upload your document.

Attach A File.jpg

Cheers!

[Glenn Kennedy]

Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

Incidentaaly, you explanation about why 2+ makes perfect sense. One silly Q, one sensible A.