Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Bernard Liengme
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to clear decimal point? Michael New Users to Excel 2 March 23rd 05 09:09 PM
Numbers after decimal point excel to word mail merge Andy P Excel Worksheet Functions 1 March 15th 05 11:48 AM
How do I enter a decimal automatically without typing it every ti. Hayley New Users to Excel 4 March 1st 05 01:21 AM
How do I override fixed decimal place settings in EXcel 2003? jroyv Excel Worksheet Functions 2 February 11th 05 06:07 PM
decimal point override does not work Sam Brauen Excel Discussion (Misc queries) 0 January 6th 05 05:29 PM


All times are GMT +1. The time now is 04:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"