| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep Trailing Zeros When Convert To Text
Is there a way any one knows about to keep the 00 portion with the dollar
amount when you convert to a text format. e.g. $234.00 converted to text to be 23400, not like it automatically does 234. The other amounts where there are actual cents work fine as we all know, but I need everything, no matter if there are pennies or not. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) | |||
| Convert postcode to text | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| convert a range of lowercase text to upper text or vice versa | Excel Worksheet Functions | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Threaded Mode
