Fix Excel cell format glitch

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim McMahon - 31 Mar 2006 20:14 GMT

In Excel 2003 if cell format is set to Date and you try to switch it to
Currency it goes to General. Then you can switch it to Currency from General
but it won't switch directly from Date. Happens every time.

Reply to this Message

Ken Wright - 31 Mar 2006 20:18 GMT

Not on mine it doesn't.

Signature

Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

> In Excel 2003 if cell format is set to Date and you try to switch it to
> Currency it goes to General. Then you can switch it to Currency from
[quoted text clipped - 10 lines]
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=6a7082e4-7e9f-4
ea7-91e8-6231350a0d4d&dg=microsoft.public.excel.crashesgpfs

Reply to this Message