How do I show numbers in Excel as 48K instead of 48000?

Posted to microsoft.public.excel.worksheet.functions

Scotty

Posts: n/a

How do I show numbers in Excel as 48K instead of 48000?

I have large numbers in Excel, i.e. 48,760. I want to display it as 48. The
column heading will indicate the number is in thousands. I can't find a
formula to round the number and only display the amount in thousands.

I understand the "round" function but can't find a suitable truncating
function.

any help?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I show break in bar graph to show large and small numbers	GK	Charts and Charting in Excel	1	December 19th 05 08:23 PM
How can I type Excel numbers to show as a barcode?	johnp	Excel Worksheet Functions	2	November 2nd 05 03:24 PM
Excel won't sort numbers correctly	martin0642	Excel Discussion (Misc queries)	2	September 27th 05 05:34 PM
How to make excel not round real numbers when making a histogram?	Leedawg	Charts and Charting in Excel	1	September 21st 05 07:36 PM
Numbers after decimal point excel to word mail merge	Andy P	Excel Worksheet Functions	1	March 15th 05 11:48 AM

All times are GMT +1. The time now is 02:50 PM.

Menu

About Us