Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Mike
 
Posts: n/a
Default Automation of Font Resizing

Select all of the cells and bump the font size down.

"Pitt" wrote:

URGENT: PLEASE HELP

I would like to know of a cell format setting, a formula, VB program, or any
other method to automatically resize the font size if the value entered is
too large and results in the display of the following: "####..." It would be
ideal if the font would downsize so that numbers could be displayed.

The cells display numbers, size 12 font, tahoma. Numbers up to 999.99
diplay, 1,000.00 (+) displays "###". Workbook was originally designed to
accomodate larger numbers using size 10 font, but other parties decided much
later in the game that they wanted larger text.

INFO: My workbook has many similar worksheets that are intended to be
changed regularly. Each workesheet has hundreds of cells that are
referenceing another worksheet's data or some other source. When a value
entered in the "referenced cell(s)" is too large, several worksheets could
have cells displaying the aformentioned error. My deadline is near and the
workbook has grown too large to make the affected cells larger (ex. by
merging more cells) to accomodate more text and/or to review each worksheet
for any affected cell.

Reply
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
Default font for Comments Debra Dalgleish Excel Worksheet Functions 0 August 25th 05 11:55 PM
Changing default font for copy / paste LaMonk Excel Discussion (Misc queries) 1 June 23rd 05 06:43 PM
Why is first font action v-e-r-y slow? [email protected] Excel Discussion (Misc queries) 2 March 11th 05 09:01 AM
xl chart font sizing into PPT Brian Reilly, MS MVP Charts and Charting in Excel 1 January 12th 05 03:58 AM
How to change the default font and size of "comments"? ClayMcQ Excel Discussion (Misc queries) 1 January 8th 05 12:43 AM


All times are GMT +1. The time now is 10:53 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"