Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Whole vs decimal
In Excel 2000, I have created a worksheet for use on a
network. Certain cells (formatted percentage) have data values that create an area chart. On my screen, I enter "75" in the source cell: "75%" shows on screen, and the chart plots a value at 75% (scale maximum is 100%). However, other users have to enter ".75" to make things work right. Is there a way to have users enter a whole number, vs a decimal? Thanks, Phil |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Whole vs decimal
That is set in Tools/Options, go to the Edit tab and check
Fixed Decimals. Problem though, every time you enter a whole number, it will move the decimal over two places unless you add a decimal point. Your other users may not like this because it is not the default way of entering data. You may want to create workbook open and close macros that toggle this setting. -----Original Message----- In Excel 2000, I have created a worksheet for use on a network. Certain cells (formatted percentage) have data values that create an area chart. On my screen, I enter "75" in the source cell: "75%" shows on screen, and the chart plots a value at 75% (scale maximum is 100%). However, other users have to enter ".75" to make things work right. Is there a way to have users enter a whole number, vs a decimal? Thanks, Phil . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Whole vs decimal
Hi Phil,
In Excel 2000, I have created a worksheet for use on a network. Certain cells (formatted percentage) have data values that create an area chart. On my screen, I enter "75" in the source cell: "75%" shows on screen, and the chart plots a value at 75% (scale maximum is 100%). However, other users have to enter ".75" to make things work right. Is there a way to have users enter a whole number, vs a decimal? Tools Options Edit Enable automatic percent entry Regards Stephen Bullen Microsoft MVP - Excel www.BMSLtd.co.uk |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify Auto_Open Sub?
Stephen, Thanks for the quick reply. Could we modify the
following Auto_Open Sub to automatically make auto percent entry setting? Sub Auto_Open() 'This code puts the cursor in cell A1 in all worksheets, 'and opens the workbook on the "Scorecard" worksheet. 'It also operates when worksheets are hidden. Application.ScreenUpdating = False For Each ws In Worksheets If ws.Visible = xlSheetVisible Then ws.Select Application.GoTo ws.Range("A1"), True ActiveWindow.DisplayGridlines = False End If Next Worksheets("Scorecard").Select Application.ScreenUpdating = True End Sub -----Original Message----- Hi Phil, In Excel 2000, I have created a worksheet for use on a network. Certain cells (formatted percentage) have data values that create an area chart. On my screen, I enter "75" in the source cell: "75%" shows on screen, and the chart plots a value at 75% (scale maximum is 100%). However, other users have to enter ".75" to make things work right. Is there a way to have users enter a whole number, vs a decimal? Tools Options Edit Enable automatic percent entry Regards Stephen Bullen Microsoft MVP - Excel www.BMSLtd.co.uk . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify Auto_Open Sub?
Mike, Thanks for the quick reply. Could we modify the
following Auto_Open Sub to automatically make auto percent entry setting? Sub Auto_Open() 'This code puts the cursor in cell A1 in all worksheets, 'and opens the workbook on the "Scorecard" worksheet. 'It also operates when worksheets are hidden. Application.ScreenUpdating = False For Each ws In Worksheets If ws.Visible = xlSheetVisible Then ws.Select Application.GoTo ws.Range("A1"), True ActiveWindow.DisplayGridlines = False End If Next Worksheets("Scorecard").Select Application.ScreenUpdating = True End Sub -----Original Message----- That is set in Tools/Options, go to the Edit tab and check Fixed Decimals. Problem though, every time you enter a whole number, it will move the decimal over two places unless you add a decimal point. Your other users may not like this because it is not the default way of entering data. You may want to create workbook open and close macros that toggle this setting. -----Original Message----- In Excel 2000, I have created a worksheet for use on a network. Certain cells (formatted percentage) have data values that create an area chart. On my screen, I enter "75" in the source cell: "75%" shows on screen, and the chart plots a value at 75% (scale maximum is 100%). However, other users have to enter ".75" to make things work right. Is there a way to have users enter a whole number, vs a decimal? Thanks, Phil . . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify Auto_Open Sub?
Phil,
simply done Sub Auto_Open() 'This code puts the cursor in cell A1 in all worksheets, 'and opens the workbook on the "Scorecard" worksheet. 'It also operates when worksheets are hidden. Application.ScreenUpdating = False For Each ws In Worksheets If ws.Visible = xlSheetVisible Then ws.Select Application.GoTo ws.Range("A1"), True ActiveWindow.DisplayGridlines = False End If Next Worksheets("Scorecard").Select Application.AutoPercentEntry = True Application.ScreenUpdating = True End Sub -- HTH ------- Bob Phillips ... looking out across Poole Harbour to the Purbecks "Phil Hageman" wrote in message ... Stephen, Thanks for the quick reply. Could we modify the following Auto_Open Sub to automatically make auto percent entry setting? Sub Auto_Open() 'This code puts the cursor in cell A1 in all worksheets, 'and opens the workbook on the "Scorecard" worksheet. 'It also operates when worksheets are hidden. Application.ScreenUpdating = False For Each ws In Worksheets If ws.Visible = xlSheetVisible Then ws.Select Application.GoTo ws.Range("A1"), True ActiveWindow.DisplayGridlines = False End If Next Worksheets("Scorecard").Select Application.ScreenUpdating = True End Sub -----Original Message----- Hi Phil, In Excel 2000, I have created a worksheet for use on a network. Certain cells (formatted percentage) have data values that create an area chart. On my screen, I enter "75" in the source cell: "75%" shows on screen, and the chart plots a value at 75% (scale maximum is 100%). However, other users have to enter ".75" to make things work right. Is there a way to have users enter a whole number, vs a decimal? Tools Options Edit Enable automatic percent entry Regards Stephen Bullen Microsoft MVP - Excel www.BMSLtd.co.uk . |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify Auto_Open Sub?
Bob, I entered the code and tried it out on a users
machine. The user still has to enter a decimal, but what shows on screen in the cell is the percentage. Is this the correct outcome for the added code? If so, okay - I'll have to educate users. Phil -----Original Message----- Phil, simply done Sub Auto_Open() 'This code puts the cursor in cell A1 in all worksheets, 'and opens the workbook on the "Scorecard" worksheet. 'It also operates when worksheets are hidden. Application.ScreenUpdating = False For Each ws In Worksheets If ws.Visible = xlSheetVisible Then ws.Select Application.GoTo ws.Range("A1"), True ActiveWindow.DisplayGridlines = False End If Next Worksheets("Scorecard").Select Application.AutoPercentEntry = True Application.ScreenUpdating = True End Sub -- HTH ------- Bob Phillips ... looking out across Poole Harbour to the Purbecks "Phil Hageman" wrote in message ... Stephen, Thanks for the quick reply. Could we modify the following Auto_Open Sub to automatically make auto percent entry setting? Sub Auto_Open() 'This code puts the cursor in cell A1 in all worksheets, 'and opens the workbook on the "Scorecard" worksheet. 'It also operates when worksheets are hidden. Application.ScreenUpdating = False For Each ws In Worksheets If ws.Visible = xlSheetVisible Then ws.Select Application.GoTo ws.Range("A1"), True ActiveWindow.DisplayGridlines = False End If Next Worksheets("Scorecard").Select Application.ScreenUpdating = True End Sub -----Original Message----- Hi Phil, In Excel 2000, I have created a worksheet for use on a network. Certain cells (formatted percentage) have data values that create an area chart. On my screen, I enter "75" in the source cell: "75%" shows on screen, and the chart plots a value at 75% (scale maximum is 100%). However, other users have to enter ".75" to make things work right. Is there a way to have users enter a whole number, vs a decimal? Tools Options Edit Enable automatic percent entry Regards Stephen Bullen Microsoft MVP - Excel www.BMSLtd.co.uk . . |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify Auto_Open Sub?
Have the user enter 75%
it will be stored as 0.75 and displayed as 75% or If you preformat the range as %, then the user can just enter 75 and it will be interpreted correctly. Regards, Tom Ogilvy "Phil Hageman" wrote in message ... Bob, I entered the code and tried it out on a users machine. The user still has to enter a decimal, but what shows on screen in the cell is the percentage. Is this the correct outcome for the added code? If so, okay - I'll have to educate users. Phil -----Original Message----- Phil, simply done Sub Auto_Open() 'This code puts the cursor in cell A1 in all worksheets, 'and opens the workbook on the "Scorecard" worksheet. 'It also operates when worksheets are hidden. Application.ScreenUpdating = False For Each ws In Worksheets If ws.Visible = xlSheetVisible Then ws.Select Application.GoTo ws.Range("A1"), True ActiveWindow.DisplayGridlines = False End If Next Worksheets("Scorecard").Select Application.AutoPercentEntry = True Application.ScreenUpdating = True End Sub -- HTH ------- Bob Phillips ... looking out across Poole Harbour to the Purbecks "Phil Hageman" wrote in message ... Stephen, Thanks for the quick reply. Could we modify the following Auto_Open Sub to automatically make auto percent entry setting? Sub Auto_Open() 'This code puts the cursor in cell A1 in all worksheets, 'and opens the workbook on the "Scorecard" worksheet. 'It also operates when worksheets are hidden. Application.ScreenUpdating = False For Each ws In Worksheets If ws.Visible = xlSheetVisible Then ws.Select Application.GoTo ws.Range("A1"), True ActiveWindow.DisplayGridlines = False End If Next Worksheets("Scorecard").Select Application.ScreenUpdating = True End Sub -----Original Message----- Hi Phil, In Excel 2000, I have created a worksheet for use on a network. Certain cells (formatted percentage) have data values that create an area chart. On my screen, I enter "75" in the source cell: "75%" shows on screen, and the chart plots a value at 75% (scale maximum is 100%). However, other users have to enter ".75" to make things work right. Is there a way to have users enter a whole number, vs a decimal? Tools Options Edit Enable automatic percent entry Regards Stephen Bullen Microsoft MVP - Excel www.BMSLtd.co.uk . . |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify Auto_Open Sub?
Once again, thanks Tom. Have done as you say. Will try
it out. Phil -----Original Message----- Have the user enter 75% it will be stored as 0.75 and displayed as 75% or If you preformat the range as %, then the user can just enter 75 and it will be interpreted correctly. Regards, Tom Ogilvy "Phil Hageman" wrote in message ... Bob, I entered the code and tried it out on a users machine. The user still has to enter a decimal, but what shows on screen in the cell is the percentage. Is this the correct outcome for the added code? If so, okay - I'll have to educate users. Phil -----Original Message----- Phil, simply done Sub Auto_Open() 'This code puts the cursor in cell A1 in all worksheets, 'and opens the workbook on the "Scorecard" worksheet. 'It also operates when worksheets are hidden. Application.ScreenUpdating = False For Each ws In Worksheets If ws.Visible = xlSheetVisible Then ws.Select Application.GoTo ws.Range("A1"), True ActiveWindow.DisplayGridlines = False End If Next Worksheets("Scorecard").Select Application.AutoPercentEntry = True Application.ScreenUpdating = True End Sub -- HTH ------- Bob Phillips ... looking out across Poole Harbour to the Purbecks "Phil Hageman" wrote in message ... Stephen, Thanks for the quick reply. Could we modify the following Auto_Open Sub to automatically make auto percent entry setting? Sub Auto_Open() 'This code puts the cursor in cell A1 in all worksheets, 'and opens the workbook on the "Scorecard" worksheet. 'It also operates when worksheets are hidden. Application.ScreenUpdating = False For Each ws In Worksheets If ws.Visible = xlSheetVisible Then ws.Select Application.GoTo ws.Range("A1"), True ActiveWindow.DisplayGridlines = False End If Next Worksheets("Scorecard").Select Application.ScreenUpdating = True End Sub -----Original Message----- Hi Phil, In Excel 2000, I have created a worksheet for use on a network. Certain cells (formatted percentage) have data values that create an area chart. On my screen, I enter "75" in the source cell: "75%" shows on screen, and the chart plots a value at 75% (scale maximum is 100%). However, other users have to enter ".75" to make things work right. Is there a way to have users enter a whole number, vs a decimal? Tools Options Edit Enable automatic percent entry Regards Stephen Bullen Microsoft MVP - Excel www.BMSLtd.co.uk . . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert decimal commas to decimal points? | Excel Discussion (Misc queries) | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
Batch converting CSV files from comma-decimal to period-decimal | Excel Discussion (Misc queries) | |||
Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) |