Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to automatically add 000 at the back of my numbers?
How to automatically add 000 at the back of my numbers?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to automatically add 000 at the back of my numbers?
If they are NUMBERS (not TEXT) multiply them by 1000. If they are TEXT
concatenate the cells with "000" i.e. =A1 & "000" OR =VALUE(A1)*1000; the latter will convert the text to number format. HTH "devillsad" wrote: How to automatically add 000 at the back of my numbers? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
numbers automatically format | Excel Worksheet Functions | |||
Form Numbers Automatically Increment by 1 Upon Opening | New Users to Excel | |||
Numbers change to dates automatically | Excel Discussion (Misc queries) | |||
automatically close hyperlink with back button | Excel Worksheet Functions | |||
how do I make a word typed in a cell go to a specific cell in anot | Excel Discussion (Misc queries) |