LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Fixed Decimal point

I know This is an excel newsgroup But I cant seem to find the answer to my
question anywhere so I figured I would ask it here.

I am using Quattro pro and I want to be able to fix a few cells decmal
points like you can do on an adding machine. Example if I were to type 1234
it would automaticly show up as 12.34. Ideally I would like 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


 
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
Help with fixed decimal Steve Excel Discussion (Misc queries) 4 December 2nd 08 07:31 PM
Converting 2-place decimal value to floating point decimal number with leading zero Kermit Piper Excel Discussion (Misc queries) 3 March 18th 06 06:20 PM
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. SUKYKITTY Excel Discussion (Misc queries) 3 July 6th 05 01:50 PM
Fixed decimal point. Wesley Excel Programming 2 January 27th 05 09:17 PM
averaging from a fixed point to a non-fixed point? Nascent Excel Programming 2 May 24th 04 05:41 AM


All times are GMT +1. The time now is 10:39 PM.

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

About Us

"It's about Microsoft Excel"