PC Review


Reply
Thread Tools Rate Thread

How to add 'ft' to number input in cell - as in 25ft

 
 
bethgames
Guest
Posts: n/a
 
      14th Dec 2007
Can someone help with this in Excel 2007??
 
Reply With Quote
 
 
 
 
Roger Govier
Guest
Posts: n/a
 
      14th Dec 2007
Hi Beth

the same as in earlier versions of Excel
Format>Cell>Number>Custom> 0.0 "ft"

Set the number of decimal places you want as appropriate.
25 entered in the cell will show as 25.0 ft with the above format. All that
is stored is the number 25, which can be used in subsequent calculations.
--

Regards
Roger Govier

"bethgames" <(E-Mail Removed)> wrote in message
news:20C4EA55-06C0-4C51-BD51-(E-Mail Removed)...
> Can someone help with this in Excel 2007??


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lock cell for number input msnews.microsoft.com Microsoft Excel Discussion 3 23rd Jun 2009 12:15 PM
Re: trying to input number from another cell automatically RagDyeR Microsoft Excel Worksheet Functions 0 10th Aug 2004 04:33 PM
making a cell fixed number to a input number fwday Microsoft Excel Misc 1 25th Oct 2003 03:03 AM
making a cell fixed number to a input number fwday Microsoft Excel Programming 1 25th Oct 2003 02:38 AM
making a cell fixed number to a input number fwday Microsoft Excel Misc 9 22nd Oct 2003 03:48 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:42 PM.