Why are there pound signs in my excel cell

Added on Tue, Jul 7, How do I copy a formula in Excel? Added on Mon, Jun 29, How do I move pages in Word ? Added on Tue, Jul 14, In Word how do you save a single page as a PDF? How do I turn tables in Excel to switch columns to rows and vice versa? How do I remove the Microsoft Office Update reminder notice? Added on Tue, May 15, Added on Mon, Jul 20, Word is acting really strange. Added on Thu, Jul 9, All Categories.

ActivStudio and Interactive Whiteboards BYOD 2. District Mobile Devices Email, Calendars and Contacts in Outlook Login Accounts and Passwords Mac OS and Applications BiTech 3. Filemaker RunTime Solutions 0. Alternatively, you could simply double click on the right edge of the cell.

This will adjust the column width to the size of the widest cell in the column. In most cases, this is not the best solution. But if you want to keep the column widths as is, this does the trick. If you have a number or a formula in your cell, that returns a number, then try reducing the number of decimal places. Regards richgoof. Hi or you can go to controle panel , regional setting, language and detail if it is not added in upper drop down list click add and select english UK remove any other languages Regards.

Mark the thread as solved if you are satisfied with the answer. In your first post under the thread tools. Entering Symbols With The Keyboard If you know the code number, you can enter that character any time by holding down the ALT key, and typing the 4-digit code number on the numeric keypad the keys on the far right of your keyboard -- do not use the "normal" number keys above the letter keys.

Even though character code numbers are only three digits between 0 and , you must type in the leading zeros to ensure that you get the proper character. For example, to enter in the British Pound sign, whose code is , hold down the ALT key, and type on the numeric keypad.

Use code tags for VBA. Saved it and the same thing happened. Does anyone know why this happens and how to fix it? This behavior will occur if the following conditions are true:. Steps to Change to the Date System. You can use the TEXT function to change the display of the negative number.

For example, if you are subtracting A2 from A1 and you want the results displayed as a time format, you can use a formula similar to the following:. The above formula will display the value as text.

You may need to format the cell alignment to right justified. Was this reply helpful?