LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Armor
 
Posts: n/a
Default Format a cell with a custom number format

I would like to type in a number and if the number meets a certain criteria,
return that number with a unit identifier.

I.E. a number "A1<= 9.9" returns "value for A1GHz" and if "A1=100, A1<=999"
returns "value for A1MHz"

I would to type a single place, decimal digit under 10 and get that value
with the unit identifier "GHz". By the same token, if the number is greater
100, but less than 999, show the value with the identifier "MHz".

Thank You
 
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
change custom format number to text joey Excel Discussion (Misc queries) 3 September 20th 05 09:35 PM
Linking customer number format to a cell Bobak Excel Discussion (Misc queries) 2 August 8th 05 08:09 PM
Custom number format always defaults last number to 0. scubadave Excel Discussion (Misc queries) 2 June 15th 05 10:20 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Format Cell (Number Custom) barryderay Excel Discussion (Misc queries) 1 April 28th 05 12:18 AM


All times are GMT +1. The time now is 06:30 AM.

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

About Us

"It's about Microsoft Excel"