| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL: display number in '000s ie £15000 show as £15
Trying to find function that will take number and round down and show as
multiple of 1000's. ie. £15000 will show as £15. MROUND does not seem to be the right formula. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
EXCEL: display number in '000s ie £15000 show as £15
You can us a custom format to do that without affecting the real value
0,;-0;0 -- HTH Bob Phillips (remove nothere from email address if mailing direct) "JILL" wrote in message ... Trying to find function that will take number and round down and show as multiple of 1000's. ie. £15000 will show as £15. MROUND does not seem to be the right formula. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
EXCEL: display number in '000s ie £15000 show as £15
perfect thanks
"Bob Phillips" wrote: You can us a custom format to do that without affecting the real value 0,;-0;0 -- HTH Bob Phillips (remove nothere from email address if mailing direct) "JILL" wrote in message ... Trying to find function that will take number and round down and show as multiple of 1000's. ie. £15000 will show as £15. MROUND does not seem to be the right formula. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show week number in current month | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| How can I display a number as a ratio of x:1 in Excel? | Excel Worksheet Functions | |||
| Can you display numbers as words in excel (eg. 10 as ten)? | Excel Discussion (Misc queries) | |||
| Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Linear Mode
