| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing leading zero from cent amounts
I am receiving a zero in front of the decimal point when I enter a cent
amount,e.g., 0.50 when I want .50 in the cell. I am using Microsoft Excel 2000. I want to prevent this from happening. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing leading zeros from a group of numbers | Excel Discussion (Misc queries) | |||
| Removing leading 0s | Excel Discussion (Misc queries) | |||
| Removing leading single quote (') from cells with Search/Replace | Excel Discussion (Misc queries) | |||
| removing leading zeros in numeric fields | Excel Discussion (Misc queries) | |||
| Removing leading decimals for text list | Excel Discussion (Misc queries) | |||
Threaded Mode
