| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 VBA - Removing leading zeroes from negatives
I have a cell with the following value
-0001,000,000 When I format it as currency, it keeps diplaying just as above. I wan it to display as ($1,000,000) Which is achived as soon as I apply the correct formatting and remov the leading zeroes I can set the formatting fine in a macro, but I am not sure how to ge rid of the leading zeroes. Any help is appreciated. Thanks, Mar -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2000 VBA - Removing leading zeroes from negatives
Hi
how have you inserted this value (imported from a different source?) -- Regards Frank Kabel Frankfurt, Germany I have a cell with the following value -0001,000,000 When I format it as currency, it keeps diplaying just as above. I want it to display as ($1,000,000) Which is achived as soon as I apply the correct formatting and remove the leading zeroes I can set the formatting fine in a macro, but I am not sure how to get rid of the leading zeroes. Any help is appreciated. Thanks, Marc --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing Leading Zeroes in Excel | New Users to Excel | |||
| Leading Zeroes | Excel Discussion (Misc queries) | |||
| Leading Zeroes | Excel Discussion (Misc queries) | |||
| CSV leading zeroes | Excel Discussion (Misc queries) | |||
| How do I format data cells in Excel to keep leading zeroes? | Setting up and Configuration of Excel | |||
![sub_pop[_12_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
