Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
In Excel you use Tool|Option; open Edit tab; click Fixed Decimal area and
type 2 Now when you type 5, Excel will record 0.50 If you forget to unset this you get a headache the next time you use Excel! I looked for an option in QP and tried Help. Found nothing. Why not post the question on the Corel QP newsgroup? best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "dave" wrote in message ... Hi I know this newsgroup is for Excel but I cant seem to find an answer to my question anywhere, so I figured I would try my luck here. I am using Quattro pro and I was wondering if anybody out there could tell me how I could setup a few specific cells to automaticly put a decimal point in like you can do on an adding machine. Example if I were to type 1234 it would automaticly show up as 12.34. Ideally if I could get it to show up as $12.34. I was using Excell at work and found something that moved the decimal over for me, but it did it for the whole page not just where I needed it. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to clear decimal point? | New Users to Excel | |||
Numbers after decimal point excel to word mail merge | Excel Worksheet Functions | |||
How do I enter a decimal automatically without typing it every ti. | New Users to Excel | |||
How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions | |||
decimal point override does not work | Excel Discussion (Misc queries) |