| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying the number of a custom formatted number cell
Thanks!
"David Biddulph" wrote: =5100&A1 -- David Biddulph "fbvideo" wrote in message ... I've formatted column A with a custom: 5100# so that when I type a number in the column it adds the 5100 in front of the number I typed. Now I want to copy the new formatted numbers into column B with the 5100 in front of it. I can't get it to keep the formatting and when I paste, it only pastes the number I typed without the 5100 in front of it. Is there an easy way to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Format a cell with a custom number format | Excel Worksheet Functions | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
