Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
1000 to 1 and 1 to 1000
When I type 1000 in one cell and then push enter, I would like that only 1 is
shown. Vice versa, typing 1 €“ I would like the cell to show 1000. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
1000 to 1 and 1 to 1000
This Change-event code might be what you're looking for.....
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Target = 1 Then Target.Value = 1000 Else If Target = 1000 Then Target.Value = 1 Else End If End If End Sub Vaya con Dios, Chuck, CABGx3 "Olle" wrote: When I type 1000 in one cell and then push enter, I would like that only 1 is shown. Vice versa, typing 1 €“ I would like the cell to show 1000. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
1000 to 1 and 1 to 1000
"Olle" wrote in message
... When I type 1000 in one cell and then push enter, I would like that only 1 is shown. Vice versa, typing 1 - I would like the cell to show 1000. You could use Tools/ AutoCorrect Options, but it sounds a dangerous way of asking your sheet to behave. -- David Biddulph |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
1000 to 1 and 1 to 1000
Chuck,
you speak of the Change event but you are giving a SelectionChange routine. With this one 1 and 1000 will be toggled whenever one clicks on a cell containing either value. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Value = 1 Or Target.Value = 1000 Then Application.EnableEvents = False If Target.Value = 1 Then Target.Value = 1000 Else Target.Value = 1 End If Application.EnableEvents = True End If End Sub HTH Kostis Vezerides |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
1000 to 1 and 1 to 1000
I found the answer my self:
Tools €“ options €“ Edit and look for fixed decimal places. Thanks anyhow // Olle "Olle" wrote: When I type 1000 in one cell and then push enter, I would like that only 1 is shown. Vice versa, typing 1 €“ I would like the cell to show 1000. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
1000 to 1 and 1 to 1000
Yes, but that would only work in one direction or the other, but not both.
-- David Biddulph "Olle" wrote in message ... I found the answer my self: Tools - options - Edit and look for fixed decimal places. Thanks anyhow // Olle "Olle" wrote: When I type 1000 in one cell and then push enter, I would like that only 1 is shown. Vice versa, typing 1 - I would like the cell to show 1000. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import 1000 webs to Explorer from Excel. | Excel Discussion (Misc queries) | |||
Continue formula to LINE 1000 without showing FALSE | Excel Worksheet Functions | |||
how do I see more than 1000 records filtered | Excel Discussion (Misc queries) | |||
Function Help | Excel Worksheet Functions | |||
Amortization Schedule | Excel Worksheet Functions |