| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Currency autofit
Hi
I'm using Excel 2000 (yes, I know) and when cells are formatted to Currency (with a £ sign at the beginning) the autofit doesn't work. I end up with ##### in the cells. It seems that Excel is autofitting to the biggest number rather than the biggest number with a £ at the beginning. Has anyone seen this before and, more importantly, is there an easy way round it? I need it to work correctly for a macro I'm writing. Thanks. maccboy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rows().AutoFit starts a calculation, but Columns().AutoFit doesn't | Excel Programming | |||
| Rows().AutoFit starts a calculation, but Columns().AutoFit doesn't | Excel Programming | |||
| How to add new currency Symbol in Format/Cell/Currency | Excel Discussion (Misc queries) | |||
| Autofit (Columns.EntireColumn.AutoFit) does not work | Excel Discussion (Misc queries) | |||
| Conversion from currency value to currency text format | Excel Programming | |||
![maccboy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
