Home |
Search |
Today's Posts |
#1
|
|||
|
|||
custom formatting
I want my list of data to appear like this:
234.1 1234 1234.2 234 with the decimal points lining up, but with NO Decimal point SHOWING if it's a whole number. I tried this format: ????.? but the decimal point still shows: 234.1 1234. 1234.2 234. Does anyone know how to make the decimal point go away (for whole numbers), but still get the column to line up there? Thanks. |
#2
|
|||
|
|||
I don't think you're going to get it using the number format.
But you could use a worksheet event. If you're typing the values in, you can use something like this: Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub If Intersect(Target, Me.Range("a:a")) Is Nothing Then Exit Sub With Target If IsNumeric(.Value) Then If CLng(.Value) = .Value Then .NumberFormat = "##0_._?" Else .NumberFormat = "##0.?" End If End If End With End Sub Right click on the worksheet tab that should have this behavior. Select view code and paste this into the code window. I used column A in my code. Change this to what you need. If Intersect(Target, Me.Range("a:a")) Is Nothing Then Exit Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Lara Shook wrote: I want my list of data to appear like this: 234.1 1234 1234.2 234 with the decimal points lining up, but with NO Decimal point SHOWING if it's a whole number. I tried this format: ????.? but the decimal point still shows: 234.1 1234. 1234.2 234. Does anyone know how to make the decimal point go away (for whole numbers), but still get the column to line up there? Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Formatting a number | Excel Discussion (Misc queries) | |||
Formatting dates in the future | Excel Worksheet Functions | |||
Custom Number formatting | Excel Worksheet Functions | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Custom formatting | Excel Discussion (Misc queries) |