Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom number formatting
I have a spreadsheet with tariff numbers in a column already in the following
format: 9018.90.8000 and I want to be able to: 1. eliminate the "periods" in the current column 2. once I enter new tariffs have the column formatted (line you can social security or phone numbers) Can anyone help me...please. Lonnie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want to custom formatting a number similar to @,@ for text. | Excel Discussion (Misc queries) | |||
Custom Number Format | Excel Discussion (Misc queries) | |||
Custom number formats | Excel Worksheet Functions | |||
Auto Formatting Custom Number | Excel Discussion (Misc queries) | |||
Pivot Table Drill Down Number Formatting | Excel Discussion (Misc queries) |