| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to program data entry to avoid zeros or last 5 digit.
How to set Cell format so enterd numbered shows figers in millions with two
decimals. Example: Like to enter $3,234,856 Excel should show $3.23 I can title excel "all numbers are in 10,000 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to program data entry to avoid zeros or last 5 digit.
Format|cells|number tab|custom category:
$#.00,, sevek wrote: How to set Cell format so enterd numbered shows figers in millions with two decimals. Example: Like to enter $3,234,856 Excel should show $3.23 I can title excel "all numbers are in 10,000 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Excel as Data Entry into Access Database | Excel Discussion (Misc queries) | |||
| Data entry for two worksheets | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| In Excel, how do I sort a column by the LAST digit of the data? | Excel Discussion (Misc queries) | |||
Linear Mode
