Home   :  Code   :  Forums   :  Submit   :  Mailing List   :  About   :  Contact

A1VBCode Forums Home    Search    Members    Calendar    Who's On

Welcome Guest ( Login | Register )       Recent Posts    Popular Topics

Home » Classic Visual Basic (VB 6 or earlier) » VBA(Excel, Word, etc...) » How do I make an excel spreadsheet calculate...

How do I make an excel spreadsheet calculate... Rate Topic Display Mode Topic Options Author Message lee91 Posted 6/22/2010 8:10:41 AM Forum Newbie Group: Forum Members Last Login: 8/5/2010 7:27:09 AM Posts: 3, Visits: 4 Hi, How can I format the cells in an excel spreadsheet so that 1 would have a value of 0.14 rather than 0.10; so for instance 3 minus 0.3 would have an answer of 2.11? corporate hospitality packages Post #29363 Steve121 Posted 7/9/2010 6:55:36 AM Forum Newbie Group: Forum Members Last Login: 7/9/2010 6:54:21 AM Posts: 3, Visits: 3 Excel uses a decimal system (base 10). I gather stones is base 14. I don't think you can do it. Buttons And Triangles In Cells Post #29420 Liliane Posted 8/17/2011 1:40:34 AM Forum Newbie Group: Banned Members Last Login: 10/29/2011 12:00:19 AM Posts: 5, Visits: 15 Thanks for the reply steve i also have the same problem Chicago Web Design|Chicago SEO|Chicago Web Development Post #30565 nichetech Posted 10/31/2011 8:32:49 AM Forum Newbie Group: Forum Members Last Login: 10/31/2011 8:47:18 AM Posts: 7, Visits: 5 You can use decimal upto the limit you need. Even you have a option of rounded off. Android Application Development | Android Application Developer | Web Development Firm Post #30848 « Prev Topic | Next Topic »

Reading This Topic Active Users: 1 (1 guest, 0 members, 0 anonymous members) No members currently viewing this topic. Forum Moderators: Admin, Mod, Mark, Keithuk

Permissions You cannot post new topics. You cannot post topic replies. You cannot post new polls. You cannot post replies to polls. You cannot edit your own topics. You cannot delete your own topics. You cannot edit other topics. You cannot delete other topics. You cannot edit your own posts. You cannot edit other posts. You cannot delete your own posts. You cannot delete other posts. You cannot post events. You cannot edit your own events. You cannot edit other events. You cannot delete your own events. You cannot delete other events. You may send private messages. You cannot send email's. You may read topics. You cannot rate topics. You cannot vote within polls. You cannot upload attachments. You may download attachments. You cannot post HTML code. You cannot edit HTML code. You cannot post IFCode. You cannot post JavaScript. You cannot post EmotIcons. You cannot post or upload images.

Forum Jump...----------------Forum HomeSearchMembers ListCalendarWho's Online---------------- Announcements  |-- Announcements .NET Programming (VB 2010 or earlier)  |-- Visual Basic .NET  |-- ASP.NET  |-- C# Classic Visual Basic (VB 6 or earlier)  |-- General Visual Basic  |-- Database Programming  |-- COM/ActiveX  |-- API  |-- Internet/Communications Programming  |-- VBA(Excel, Word, etc...)  |-- Game Programming General Discussion  |-- Forum Feedback  |-- Member Chat  |-- Introductions All times are GMT -5:00, Time now is 11:00pm