| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format column to have different decimal places
On my spread sheet I have a column with different equipment numbers. If the
number starts with 25 it needs to have 4 decimal places (25.4444) if it starts with a 26 it needs to have 3 decimal places (26.333). Not sure how to do this we tried conditional formatting and it does not give decimal as option. We tried to format as general but it would drop the zero off the end. Example 26.330 would be 26.33. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| worksheet is set up for 2 decimal places but format changes | Excel Discussion (Misc queries) | |||
| format issues with decimal places | Excel Discussion (Misc queries) | |||
| decimal places in format cell | Excel Discussion (Misc queries) | |||
| Formula for: Format Decimal places? | Excel Discussion (Misc queries) | |||
| My numbers format as a number with two decimal places. | Excel Discussion (Misc queries) | |||
Threaded Mode
