LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default enter 45, display 45 kilos

How to format a cell so that it will display a number entered with the units
desired. eg. if you enter 345, it will display 345 days, kilos, miles etc.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Formula for Converting Kilos to Stones Paulf[_2_] Excel Worksheet Functions 3 May 26th 07 05:55 PM
How do I enter a SSN but only display the last four digits? Caspar Excel Discussion (Misc queries) 1 August 5th 06 01:57 AM
how do I enter a value, display that many fields? Ant Excel Discussion (Misc queries) 1 June 9th 06 05:23 PM
does anyone have a chart for weight gain or loss in kilos? Robynr Excel Discussion (Misc queries) 3 January 9th 06 12:01 PM
Numbers display as decimal, i.e. enter 123 display 1.23 IGH219 Setting up and Configuration of Excel 1 June 16th 05 09:16 PM


All times are GMT +1. The time now is 09:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"