Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I enter $1225 as $12.25 without typeing the decmial?
in excel I wat to enter dollars and cent with out typeing in the decmial.
The same way you do in an adding machine |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I enter $1225 as $12.25 without typeing the decmial?
Toolsoptions...Editfixed decimals and 2
-- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "stayton" wrote in message ... in excel I wat to enter dollars and cent with out typeing in the decmial. The same way you do in an adding machine |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I enter $1225 as $12.25 without typeing the decmial?
Nick,
Doesn't that mean ALL entries are of that form? How would you do it if only one column was required to be as requested? "Nick Hodge" wrote: Toolsoptions...Editfixed decimals and 2 -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "stayton" wrote in message ... in excel I wat to enter dollars and cent with out typeing in the decmial. The same way you do in an adding machine |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I enter $1225 as $12.25 without typeing the decmial?
You couldn't. You could use a helper column
=A2/100 This could then be copied over You could take a cell with 100 in, copy it and then select your data and EditPaste special....Values and divide or you could set up some code in the worksheet_change() event, but this may be overkill...be quite easy to code -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Toppers" wrote in message ... Nick, Doesn't that mean ALL entries are of that form? How would you do it if only one column was required to be as requested? "Nick Hodge" wrote: Toolsoptions...Editfixed decimals and 2 -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "stayton" wrote in message ... in excel I wat to enter dollars and cent with out typeing in the decmial. The same way you do in an adding machine |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I enter $1225 as $12.25 without typeing the decmial?
Original Question:
in excel I wat to enter dollars and cent with out typeing in the decmial. The same way you do in an adding machine Toppers interpretation: if only one column was required to be as requested? Based on the question asked, sounded like that is what was wanted (fixed decimal) - there was no mention of a single column. -- Regards, Tom Ogilvy "Toppers" wrote in message ... Nick, Doesn't that mean ALL entries are of that form? How would you do it if only one column was required to be as requested? "Nick Hodge" wrote: Toolsoptions...Editfixed decimals and 2 -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "stayton" wrote in message ... in excel I wat to enter dollars and cent with out typeing in the decmial. The same way you do in an adding machine |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I enter $1225 as $12.25 without typeing the decmial?
Toppers
For just one column you would need event code. Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range("A:A")) Is Nothing Then With Target If .Value < "" Then .Value = .Value / 100 .NumberFormat = "$#,##0.00" 'remove the $ sign if don't want currency format End If End With End If ws_exit: Application.EnableEvents = True End Sub Right-click your worksheet tab and "View Code". Copy/paste into that module. Enter 1234 in A1 and see $12.34 returned. Gord Dibben Excel MVP On Sun, 8 May 2005 00:40:01 -0700, "Toppers" wrote: Nick, Doesn't that mean ALL entries are of that form? How would you do it if only one column was required to be as requested? "Nick Hodge" wrote: Toolsoptions...Editfixed decimals and 2 -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "stayton" wrote in message ... in excel I wat to enter dollars and cent with out typeing in the decmial. The same way you do in an adding machine |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter multiple numbers in a cell so total shows when enter keypres | Excel Worksheet Functions | |||
Update one cell as soon as you start typeing in another | Excel Discussion (Misc queries) | |||
Ctrl+Shift+! for two decmial places with thousand separator | Excel Discussion (Misc queries) | |||
Typeing zero as first number of a string | Excel Discussion (Misc queries) | |||
Hexidecimal dn decmial data | Excel Programming |